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
