Yup, they are.
I am running CF5 by the way on w2k server
-----Original Message-----
From: Adkins, Randy [mailto:[EMAIL PROTECTED]]
Sent: 19 July 2001 11:32
To: CF-Talk
Subject: RE: cross-posting: data type mismatch
Double check the data types in the database for both fields. Testname
should
be text and the other number/integer
-----Original Message-----
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 19, 2001 6:25 AM
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
