Hi, I had this error at some times, it was very difficult to reproduce.
The error has already been discussed on: http://www.mail-archive.com/[email protected]/msg05058.html The error is: ODBC Error Code = 22003 (Numeric value out of range) [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error converting float to data type numeric. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (91:1) to (91:67). The error occurred while processing an element with a general identifier of (CFRETHROW), occupying document position (194:3) to (194:13). After ODBC tracing, etc... the solution was clear : I change the "objects" table field called something like "createdatetime" and "lastupdateddatetime" from NUMERIC to FLOAT. The problem disappear then. I am a novice in Coldfusion/Spectra so any feedback is welcome. Cheers, Vincent. ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
