Skip to main content
Inspiring
December 29, 2008
Question

SQL Err

  • December 29, 2008
  • 2 replies
  • 378 views
[Macromedia][SQLServer JDBC Driver][SQLServer]Arithmetic overflow error converting real to data type numeric on Line 57

Line 57 :
AND EID = <cfqueryparam cfsqltype="CF_SQL_CHAR" value="#arguments.EID#">
This topic has been closed for replies.

2 replies

Inspiring
December 29, 2008
emmim44 wrote:
> [Macromedia][SQLServer JDBC Driver][SQLServer]Arithmetic overflow error
> converting real to data type numeric on Line 57

http://letmegooglethatforyou.com/?q=Arithmetic+overflow+error+%20+converting+real+to+data+type+numeric

Interesting results:
http://forums.devshed.com/ms-sql-development-95/arithmetic-overflow-error-converting-numeric-to-data-type-numeric-89157.html
http://support.microsoft.com/default.aspx?scid=kb;EN-US;155710

Please include more details about your problem in the future (software
versions, etc) and remember: google first ask questions later.

--
Mack
Inspiring
December 29, 2008
What are the data types for the MetricSnapShotID and EID columns?

What are the values of the variables this.MetricSnapShotID and arguments.EID?

Could there be a problem with the join in your SQL statement? Does the SELECT statement work without a WHERE clause?