around the queries?
> -----Original Message-----
> From: mayo [mailto:[EMAIL PROTECTED]
> Sent: vrijdag 13 februari 2004 13:29
> To: CF-Talk
> Subject: RE: inserting into multiple tables
>
> ths,
>
> 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]
