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
