with cfupdate, you have to name the form fields the same as the table fields.
if they aren't spelled exactly the same, cfupdate won't work. try using cfquery instead ... more flexibility.. and WHOA! you might learn something.:-) j ----- Original Message ----- From: "Corey Yiap" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, August 09, 2002 2:36 PM Subject: RE: Access Question > I'm using CFMX. My query is pretty simple <CFUPDATE DATASOURCE="profiles" > TABLENAME="Site"> and <CFINSERT DATASOURCE="profiles" TABLENAME="Site">. > The fields missed are pretty consistent, but there were no error. It just > doesn't write/show in the database. I got the confirm page that it was > successfully updated or inserted every time. > > corey > > > -----Original Message----- > From: jon hall [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 09, 2002 11:04 AM > To: CF-Talk > Subject: Re: Access Question > > > Some questions. > > Which CF version? > Can we see the queries? Code good, theory unproductive ;) > Are the fields that get missed consistent? > Are you able to reproduce the error, and if so what does the query > look like in the debug? > > -- > jon > mailto:[EMAIL PROTECTED] > > Friday, August 9, 2002, 1:48:00 PM, you wrote: > CY> I'm doing a project the has INSERT INTO, UPDATE and DELETE forms. My > CY> question is when I do my INSERT INTO or UPDATE, not all of my table form > CY> fields get inserted or updated. I can't figured out the glitch, > sometimes > CY> it's fine and other times it would miss a couple of fields. How can I > make > CY> sure that every fields get inserted or updated? and is there a > connection > CY> string I need to put in to make it more reliable? > > CY> Thanks, > > CY> corey > > > CY> > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
