Hi cf-talk, On Thu, 29 Mar 2001, at 12:57:55 [GMT -0500] you wrote:
CHH> Why not do two cfqueries with SQL INSERT commands for the different tables?
CHH> Hatton
There are so many fields, I'm lazy and don't want to type it all out.
I did try to use a SQL insert to replace the second CFINSERT and I
keep gettin this error:
ODBC Error Code = 22005 (Error in assignment)
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
Can I use a CFINSERT then a SQL INSERT?
>> -----Original Message-----
>> From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
>> Sent: Thursday, March 29, 2001 12:48 PM
>> To: CF-Talk
>> Subject: 2 CFINSERT on ome page?
>>
>>
>> Hello cf-talk,
>>
>> I have a form with many fields.
>>
>> The fields go to different tables.
>>
>> I'm trying to use CFINSERT with formfields to add data to different
>> tables. When I submit the form, I don't get any errors, but only the
>> first CFINSERT gets processed?
>>
>> <CFINSERT DATASOURCE="#application.DSN#" tableName="registration"
>> Formfields=" last_name, first_name, address, city, state, zip, email,
>> phone, gender, person_notify, notify_telephone, tickets_adult, adult1,
>> adult2, adult3, adult4, adult5, adult6, adult7, adult8, adult9,
>> adult10, adult11, adult12. tickets_children, child1, childage1,
>> child2, childage2, child3, childage3, child4, childage4, child5,
>> childage5, child6, childage6, child7, childage7, child8, childage8,
>> tshirtsmall, tshirtmed, tshirtlarge, tshirtxl, else, card,
>> card_number, cardholder, expdate" >
>>
>> <CFINSERT DATASOURCE="#application.DSN#" tableName="addlregs"
>> Formfields=" alastname, afirstname, aphone, card_number, first_name,
>> last_name" >
>>
>>
>> As is, only the first gets processed (makes it into the table), if I
>> comment out the top CFINSERT, then the second makes it into its table
>> and the first does nothing.
>>
>>
>>
>>
>> Best regards,
>> Jeff Fongemie mailto:[EMAIL PROTECTED]
>> ------------------------
>> Internet Guns For Hire
>> (603) 356-0768
>>
>>
>>
CHH>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists