Forums
This topic is locked
Error Occurred While Processing Request
Posted 19 Jul 2002 22:12:46
1
has voted
19 Jul 2002 22:12:46 Justin Camerer posted:
I got an error when i submitted info to a database. Here is the error i get [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] You tried to assign the Null value to a variable that is not a Variant data type.
The Error Occurred in C:\CFusionMX\wwwroot\Premier\TMPn6zlzinw6.cfm: line 189
187 : </cfif>
188 : )
189 : </cfquery>
190 : <cflocation url="thanks.cfm">
191 : </cfif>
--------------------------------------------------------------------------------
SQL INSERT INTO form (ID, "date", propertyAddress, parcelNo, briefLegalDescription, seller1, seller1SSNo, seller2, seller3SSNo, buyer1, buyer1SSNo, buyer2, buyer2SSNo, buyerMaritialStatus, oneOrMore, whoElse, lender, conact, lenderAddress, lenderPhone, lenderFax, closingDate, requestedTime, orderedBy, salePrice, priorEvidence, separateCover, copiesTo, amountMoney, holderMoney) VALUES ( NULL , NULL , '23' , '123' , 'sdfasdf' , 'asdf' , 123 , 'sdf' , 123 , 'asd' , 1234 , 'asdf' , 123 , 'Married' , 'Y' , 'dsf' , 'asdf' , 'sdfg' , '1234' , 1234 , 1234 , '1/2/34' , 'AM' , 'asdgf' , 2134 , 'Y' , 'Y' , 'sdfa' , 11234 , '13241' )
DATASOURCE Premier
VENDORERRORCODE -1504
SQLSTATE 23000
Im using coldfusion mx and dreamweaver mx. Thanks