> i tried to put two different insert statement one
> after the other but it did not work ?
The easiest thing to do would be to simply use two different CFQUERY
tags/statements one after the other such as:
<cfquery>
INSERT INTO table1 ('field1') VALUES ('#form.field1#')
</cfquery>
<cfquery>
INSERT INTO table2 ('field2') VALUES ('#form.field2#')
</cfquery>
This is simplified of course, so the usual suggestions to use
cfqueryparam apply even though I didn't include it in the sample
above. Another option, depending on your database server, is to put
both insert statements into the same cfquery tag and separate them
with an execution delimiter (such as a semicolon on ms-sql server)
which will execute both within the same tag.
-Just
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5573
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
