|
 |
asp_databases thread: JOIN tables - Urgent help required
Message #1 by "Omar Haji" <omar_haji@h...> on Thu, 22 Mar 2001 17:46:15 -0000
|
|
hi,
i have 3 INSERT statements that take user data from HTML forms and places
the data into 3 Access tables
but i am baffeld, how do i get the primary keys from these newly created
records and stick them into join table to make a whole record. This is
because when i insert i have not created a recordset and so i can not pull
the primary keys. i know how to do this method in a recordset by using the
absolute position!
This is driving me crazy, somebody pls help
TIA
Omar
Message #2 by "Ken Schaefer" <ken@a...> on Fri, 23 Mar 2001 11:10:44 +1100
|
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: i have 3 INSERT statements that take user data from HTML forms and
: places the data into 3 Access tables
:
: but i am baffeld, how do i get the primary keys from these newly created
: records and stick them into join table to make a whole record. This is
: because when i insert i have not created a recordset and so i can not pull
: the primary keys. i know how to do this method in a recordset by using the
: absolute position!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
www.adOpenStatic.com/experiments/fastestautonumber.asp
Cheers
Ken
Message #3 by "Pappas Nikos" <pappas@c...> on Fri, 23 Mar 2001 02:40:05 +0200
|
|
Hi Ken
Why don't you try to move to the last record of the existing recordset get
its primary key and add 1?
Excuse a newbie but you've been very helpful to me.
Best regards
Nikos
-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Friday, March 23, 2001 2:11 AM
To: ASP Databases
Subject: [asp_databases] Re: JOIN tables - Urgent help required
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: i have 3 INSERT statements that take user data from HTML forms and
: places the data into 3 Access tables
:
: but i am baffeld, how do i get the primary keys from these newly created
: records and stick them into join table to make a whole record. This is
: because when i insert i have not created a recordset and so i can not pull
: the primary keys. i know how to do this method in a recordset by using the
: absolute position!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
www.adOpenStatic.com/experiments/fastestautonumber.asp
Cheers
Ken
|
|
|
View Cart
