Adobe Community
All community
This category
This board
Knowledge base
Users
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forÂ
ShowÂ
 onlyÂ
|
Search instead forÂ
Did you mean:Â
Global community
Language:
Deutsch
English
Español
Français
Português
日本語コミュニティ
Dedicated community for Japanese speakers
í•œêµ ì»¤ë®¤ë‹ˆí‹°
Dedicated community for Korean speakers
Sign In
Exit
Home
ColdFusion
Discussions
SQL Err
Home
ColdFusion
Discussions
SQL Err
0
Upvote
SQL Err
emmim44
Participant
,
/t5/coldfusion-discussions/sql-err/td-p/119132
Dec 29, 2008
Dec 29, 2008
Copy link to clipboard
Copied
[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#">
TOPICS
Advanced techniques
Views
311
Translate
Translate
Report
Report
Follow
Report
More
Reply
Reply
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
2 Replies
2
Jump to latest reply
JR__Bob__Dobbs-qSBHQ2
Advisor
,
/t5/coldfusion-discussions/sql-err/m-p/119133#M11328
Dec 29, 2008
Dec 29, 2008
Copy link to clipboard
Copied
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?
Votes
0
Upvote
Translate
Translate
Report
Report
Follow
Report
More
Reply
Reply
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
Newsgroup_User
LEGEND
,
/t5/coldfusion-discussions/sql-err/m-p/119134#M11329
Dec 29, 2008
Dec 29, 2008
Copy link to clipboard
Copied
LATEST
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+numer...
Interesting results:
http://forums.devshed.com/ms-sql-development-95/arithmetic-overflow-error-converting-numeric-to-data...
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
Votes
0
Upvote
Translate
Translate
Report
Report
Follow
Report
More
Reply
Reply
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
Post Reply
Preview
Exit Preview
never-displayed
You must be signed in to add attachments
never-displayed
Â
Resources
Documentation
ColdFusion User Guide
2
Replies
AdChoices