Just a thought, did you happen to try adding the formfield attribute to your <cfinsert> statement? It's not required but who knows....
Jim Vosika http://www.softwaresupermall.com -----Original Message----- From: Chris Kief [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 5:27 PM To: CF-Talk Subject: RE: CFINSERT is dropping form fields That solved the problem...but what is going on with CFINSERT...just me or do we have a bug in there somewhere? Anyone else see similar behavior? Chris -----Original Message----- From: Jim Vosika [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 2:57 PM To: CF-Talk Subject: RE: CFINSERT is dropping form fields Have you tried using <cfquery> instead to see if atleast that works? <cfquery datasource="#request.dsn#" name="name:> INSERT INTO tblProduct (form1, form2) VALUES('value1', 'value2'); </cfquery> Jim Vosika http://www.softwaresupermall.com -----Original Message----- From: Chris Kief [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 4:14 PM To: CF-Talk Subject: CFINSERT is dropping form fields Hello all... I'm using cfinsert to add a new row to my table...problem is cfinsert is dropping (not inserting) one of the form fields like it doesn't even exist. :( I have checked everything...verified the form field names, the database column names, and checked the debug to verify that all the form fields are present on the action page. This has worked flawlessly for months in CF5. The cfinsert looks like this: <cfinsert datasource="#request.dsn#" tablename="tblPRODUCT"> I cfdump'ed the entire form scope right before the cfinsert statement and verified that _everything_ is there. Any idea what can be happening here? I'm using: CFMX & SQL Server 2000 ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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
