Hi guys,
Brain drain going on here. I am getting this error message with a simple
query:
Error Diagnostic Information
ODBC Error Code = 22005 (Error in assignment)
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria
expression.
SQL = "INSERT INTO tbl_test (testname, testnumber) VALUES ('will',
12222333444545456)"
Data Source = "dsntest"
This is the code:
<cfquery datasource="liquidid-payments" name="addtest">
INSERT INTO tbl_test
(testname, testnumber)
VALUES ('#Form.testname#', #Form.testnumber#)
</cfquery>
And the Access2000 db is set up as follows:
testname is a VARCHAR 510
testnumber is a INTEGER 4
I must have done hundreds of these kind of queries. They ALWAYS work, at
least I'm sure they do. I've tried putting '' around the value for
testnumber but then get an
ODBC Error Code = 22003 (Numeric value out of range)
[Microsoft][ODBC Microsoft Access Driver]Numeric value out of range (null)
Any ideas people??
Will Swain
Hot Horse Ltd
http://www.hothorse.com
e: [EMAIL PROTECTED]
t: 01273 675375
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
