Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 ColdFusion error with SQL Server Express

Author  Topic 

vtabb
Starting Member

4 Posts

Posted - 2006-03-14 : 19:32:36
Hello,

I am receiving hte following error when I open my ColdFusion web page.

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver]Numeric value out of range

My problem is that this doesn't seem to be referring to a numeric field. I can run my page just fine without the query asking for the field "Description", which is a varchar(max). I have another table with the same exact field (data type, properties) that is called from a different web page using ColdFusion and that one works fine. I have recreated my table, rewritten the ColdFusion query several ways, and just cannot find an answer! I can't really even decide if it's a SQL Server problem or ColdFusion.

Any ideas?
Thanks,
Nicki

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2006-03-18 : 12:12:35
Can you post the table schema and the code you're running?

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine + SQL Express
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
Go to Top of Page
   

- Advertisement -