try using CFQUERY instead of CFINSERT You can string many CFQUERY together into one
transaction.
> -----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
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
