Get ready for BLACK FRIDAY shopping starting in

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

Reply to this topic