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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
