thx to everyone who replied. I've been pulled to another project so haven't had time to implement, or even digest, what's been written.
thx again. Gilbert Midonnet -----Original Message----- From: mayo [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 7:56 PM To: CF-Talk Subject: insert multiple records into multiple tables I've gotten myself completely lost. I have a form in which I would like to insert multiple records into multiple tables. The trouble comes in grabbing the record IDs from one table and inserting them in the other. Currently I insert one record at a time. What I would like to do is to be able to insert multiple items at one time and am going nowhere fast. INSERT into table1 ( 'A', 'B', 'C' ) VALUES ( '#FORM.A#', '#FORM.B#', '#FORM.C#' ) INSERT into table2 ( 'D', 'E', 'F' ) VALUES ( '#FORM.D#', '#FORM.E#', '#FORM.F#' ) WHERE ???????? I'm totally lost. TIA Gilbert Midonnet ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
