cfupdate conundrum
All, I am running CFMX on WindowsXP Pro with MySQL database. The structure of Document Table: Field,Type,Null,Key,Default,Extra, DocumentIndex,int(11),,PRI,,auto_increment, DocumentID,smallint(6),YES DocumentName,text,YES DocumentFileName,text,YES Author,smallint(4),YES DocumentType,smallint(4),YES The results of cfdump var=#Form# AUTHOR 27 DOCUMENTENTRYFORMSUBMITBUTTON Submit Entry DOCUMENTFILENAME EmployeeEntryForm.cfm DOCUMENTID 1 DOCUMENTINDEX 12 DOCUMENTNAME Employee Entry Form DOCUMENTTYPE 1 FIELDNAMES DOCUMENTINDEX,DOCUMENTID,DOCUMENTNAME,DOCUMENTFILENAME,AUTHOR,DOCUMENTTYPE,NEWDOCUMENTTYPEBUTTON,DOCUMENTENTRYFORMSUBMITBUTTON NEWDOCUMENTTYPEBUTTON New Document Type Error from cfupdate datasource=#dbSource# username=#dbUserName# password=#dbPassword# tablename=Document formfields=DocumentIndex, DocumentID, DocumentName, DocumentFileName, Author, DocumentType Error Occurred While Processing Request Error Executing Database Query. Cannot convert class java.lang.Integer to SQL type requested The Error Occurred in C:\Program Files\Macromedia\CFusionMX\wwwroot\ISRD\application\DocumentDataEntry.cfm: line 38 36 : cfelseif IsDefined(Form.DocumentIndex) 37 :cfdump var=#Form# 38 :cfupdate datasource=#dbSource# username=#dbUserName# password=#dbPassword# tablename=Document formfields=DocumentIndex, DocumentID, DocumentName, DocumentFileName, Author, DocumentType 39 : cfelse 40 :cfset Form.DocumentIndex = CheckExistingDocumentEntry.DocumentIndex __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfupdate conundrum
Why not simply remove fields from cfupdate until it works. The last one you remove is the problem, and you don't have to think at all. - Original Message - From: Robert Polickoski [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 7:27 PM Subject: cfupdate conundrum All, I am running CFMX on WindowsXP Pro with MySQL database. The structure of Document Table: Field,Type,Null,Key,Default,Extra, DocumentIndex,int(11),,PRI,,auto_increment, DocumentID,smallint(6),YES DocumentName,text,YES DocumentFileName,text,YES Author,smallint(4),YES DocumentType,smallint(4),YES The results of cfdump var=#Form# AUTHOR 27 DOCUMENTENTRYFORMSUBMITBUTTON Submit Entry DOCUMENTFILENAME EmployeeEntryForm.cfm DOCUMENTID 1 DOCUMENTINDEX 12 DOCUMENTNAME Employee Entry Form DOCUMENTTYPE 1 FIELDNAMES DOCUMENTINDEX,DOCUMENTID,DOCUMENTNAME,DOCUMENTFILENAME,AUTHOR,DOCUMENTTYPE,N EWDOCUMENTTYPEBUTTON,DOCUMENTENTRYFORMSUBMITBUTTON NEWDOCUMENTTYPEBUTTON New Document Type Error from cfupdate datasource=#dbSource# username=#dbUserName# password=#dbPassword# tablename=Document formfields=DocumentIndex, DocumentID, DocumentName, DocumentFileName, Author, DocumentType Error Occurred While Processing Request Error Executing Database Query. Cannot convert class java.lang.Integer to SQL type requested The Error Occurred in C:\Program Files\Macromedia\CFusionMX\wwwroot\ISRD\application\DocumentDataEntry.cfm: line 38 36 : cfelseif IsDefined(Form.DocumentIndex) 37 :cfdump var=#Form# 38 :cfupdate datasource=#dbSource# username=#dbUserName# password=#dbPassword# tablename=Document formfields=DocumentIndex, DocumentID, DocumentName, DocumentFileName, Author, DocumentType 39 : cfelse 40 :cfset Form.DocumentIndex = CheckExistingDocumentEntry.DocumentIndex __ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfupdate conundrum
It has been my experience as well as the experience of other developers on this list that cfupdate is flaky at best unless your table only has a couple of fields. I have since stopped using cfupdate even with very small tables. Try putting it in a cfquery tag instead and see what happens. -Original Message- From: Robert Polickoski [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 1:27 AM To: CF-Talk Subject: cfupdate conundrum All, I am running CFMX on WindowsXP Pro with MySQL database. The structure of Document Table: Field,Type,Null,Key,Default,Extra, DocumentIndex,int(11),,PRI,,auto_increment, DocumentID,smallint(6),YES DocumentName,text,YES DocumentFileName,text,YES Author,smallint(4),YES DocumentType,smallint(4),YES The results of cfdump var=#Form# AUTHOR 27 DOCUMENTENTRYFORMSUBMITBUTTON Submit Entry DOCUMENTFILENAME EmployeeEntryForm.cfm DOCUMENTID 1 DOCUMENTINDEX 12 DOCUMENTNAME Employee Entry Form DOCUMENTTYPE 1 FIELDNAMES DOCUMENTINDEX,DOCUMENTID,DOCUMENTNAME,DOCUMENTFILENAME,AUTHOR,DOCUMENTTY PE,NEWDOCUMENTTYPEBUTTON,DOCUMENTENTRYFORMSUBMITBUTTON NEWDOCUMENTTYPEBUTTON New Document Type Error from cfupdate datasource=#dbSource# username=#dbUserName# password=#dbPassword# tablename=Document formfields=DocumentIndex, DocumentID, DocumentName, DocumentFileName, Author, DocumentType Error Occurred While Processing Request Error Executing Database Query. Cannot convert class java.lang.Integer to SQL type requested The Error Occurred in C:\Program Files\Macromedia\CFusionMX\wwwroot\ISRD\application\DocumentDataEntry.cf m: line 38 36 : cfelseif IsDefined(Form.DocumentIndex) 37 :cfdump var=#Form# 38 :cfupdate datasource=#dbSource# username=#dbUserName# password=#dbPassword# tablename=Document formfields=DocumentIndex, DocumentID, DocumentName, DocumentFileName, Author, DocumentType 39 : cfelse 40 :cfset Form.DocumentIndex = CheckExistingDocumentEntry.DocumentIndex __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfupdate conundrum
Thank you. It worked. Funny, INSERT queries bombed on me so I used cfinsert instead. I guess the transitive theory doesn't necessarily hold for database management tags. Thank you again. -- Original Message -- From: Bruce Sorge [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 24 Sep 2002 16:03:59 -0500 It has been my experience as well as the experience of other developers on this list that cfupdate is flaky at best unless your table only has a couple of fields. I have since stopped using cfupdate even with very small tables. Try putting it in a cfquery tag instead and see what happens. -Original Message- From: Robert Polickoski [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 1:27 AM To: CF-Talk Subject: cfupdate conundrum All, I am running CFMX on WindowsXP Pro with MySQL database. The structure of Document Table: Field,Type,Null,Key,Default,Extra, DocumentIndex,int(11),,PRI,,auto_increment, DocumentID,smallint(6),YES DocumentName,text,YES DocumentFileName,text,YES Author,smallint(4),YES DocumentType,smallint(4),YES The results of cfdump var=#Form# AUTHOR 27 DOCUMENTENTRYFORMSUBMITBUTTON Submit Entry DOCUMENTFILENAME EmployeeEntryForm.cfm DOCUMENTID 1 DOCUMENTINDEX 12 DOCUMENTNAME Employee Entry Form DOCUMENTTYPE 1 FIELDNAMES DOCUMENTINDEX,DOCUMENTID,DOCUMENTNAME,DOCUMENTFILENAME,AUTHOR,DOCUMENTTY PE,NEWDOCUMENTTYPEBUTTON,DOCUMENTENTRYFORMSUBMITBUTTON NEWDOCUMENTTYPEBUTTON New Document Type Error from cfupdate datasource=#dbSource# username=#dbUserName# password=#dbPassword# tablename=Document formfields=DocumentIndex, DocumentID, DocumentName, DocumentFileName, Author, DocumentType Error Occurred While Processing Request Error Executing Database Query. Cannot convert class java.lang.Integer to SQL type requested The Error Occurred in C:\Program Files\Macromedia\CFusionMX\wwwroot\ISRD\application\DocumentDataEntry.cf m: line 38 36 : cfelseif IsDefined(Form.DocumentIndex) 37 :cfdump var=#Form# 38 :cfupdate datasource=#dbSource# username=#dbUserName# password=#dbPassword# tablename=Document formfields=DocumentIndex, DocumentID, DocumentName, DocumentFileName, Author, DocumentType 39 : cfelse 40 :cfset Form.DocumentIndex = CheckExistingDocumentEntry.DocumentIndex __ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists