looks as if I'll have to migrate to MySQL or MSSQL as Access doesn't seem to
have anything of the kind.
Gil
-----Original Message-----
From: Taco Fleur [mailto:[EMAIL PROTECTED]
Sent: Friday, February 13, 2004 2:42 AM
To: CF-Talk
Subject: RE: inserting into multiple tables
<cfquery .........>
INSERT INTO .............
INSERT INTO .............
WHERE id = SCOPE_IDENTITY()
INSERT INTO .............
WHERE id = SCOPE_IDENTITY()
</cfquery>
With MS SQL anyway...
No need to perform any selects...
Taco Fleur
Blog <http://www.tacofleur.com/index/blog/>
http://www.tacofleur.com/index/blog/
Methodology http://www.tacofleur.com/index/methodology/
Tell me and I will forget
Show me and I will remember
Teach me and I will learn
-----Original Message-----
From: mayo [mailto:[EMAIL PROTECTED]
Sent: Friday, 13 February 2004 2:32 PM
To: CF-Talk
Subject: inserting into multiple tables
I have to insert data into multiple tables. I'm using 3 db calls.
After the first insert I'm immediately selecting the rowID of the insert
and
using that in the second and third inserts.
Originally the information had been inputted on different pages so there
was
no problem but now everything is on one page. It seems as if the SELECT
gets
called before the INSERT is completed.
I use the inserts in the "EDIT" page and there is no problem. However the
rowID is sent via a query_string.
Gil
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
