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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
