try this in your query: cast(testnumber as varchar)
HTH
D
___________________
Diana Nichols
Webmistress
SalesThreads - Selling Simplified
http://www.salesthreads.com
'One man's magic is another man's engineering' --Lazarus Long
-----Original Message-----
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 19, 2001 7:03 AM
To: CF-Talk
Subject: RE: cross-posting: data type mismatch
ahhhh,
of course!!!
any suggestions as to what i can use instead?
cheers
Will
-----Original Message-----
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: 19 July 2001 11:49
To: CF-Talk
Subject: RE: cross-posting: data type mismatch
Doesnt INTERGER 4 mean only intergers of length 4 will be allowed ?
> [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in
> criteria
> expression.
> testname is a VARCHAR 510
> testnumber is a INTEGER 4
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
