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> ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
