Hi,
It must be to do with the data type you have assigned for the number. If you
get 'Numeric value out of range' as an error it is probably because it is
out of range for a short integer(-32768 to 32767) or an
integer(-2,147,483,648 to 2,147,483,647 ) . Try using a long or a double if
you want very long numbers.
I hope that helps
Stephen
-----Original Message-----
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: 19 July 2001 11:25
To: CF-Talk
Subject: cross-posting: data type mismatch
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
