Using SQL Server 2k and CFMX 6.1 on a Win2k box. Has anyone had any problems returning smalldatetime columns from a database? I keep getting this error:
Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver]Numeric value out of range. And I've narrowed it down to a "datecreated" column that is a smalldatetime. The column returns correct information in Query Analyzer, so I expect that it's something on the CF side of things. If I change the column to "datetime" it works... this screams bug to me, but I'm wondering if I'm the only one encountering this... The is only happening on one of our 5 boxes, so it's probably just a fluke and restarting either CF or SQL might do the trick... Thoughts? -d ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138312 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com