Hi Jeff,
You need to do an SQL insert for each table you want to insert data into. Just line
them up one after the other on
the page that processes the form.
Frank Hilliard
http://www.bcinternet.com/~hilliard
Jeff Fongemie wrote:
> 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
