People actually use CFINSERT?
----- Original Message -----
From: "C. Hatton Humphrey" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 29, 2001 10:57 AM
Subject: RE: 2 CFINSERT on ome page?
> Why not do two cfqueries with SQL INSERT commands for the different
tables?
>
> Hatton
>
> > -----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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
