>> 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
thanks al ot just..
ll see what is wrong with my cf queries then
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:5574
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
