Status/Resolution/Reason: Closed/Fixed/
Reporter/Name(from Bugbase): ryan eberly / ryan eberly (ryanheberly)
Created: 09/13/2012
Components: Database
Versions: 10.0
Failure Type: Data Corruption
Found In Build/Fixed In Build: Final / 286244
Priority/Frequency: Critical / Some users will encounter
Locale/System: English / Windows 7 64-bit
Vote Count: 0
Problem Description:
'300D' is incorrectly typed to a number and then fails. This is a little tricky in that your app can work for years, until a number followed by 'D' is entered.
I reported this 2 years ago, and was surprised to see it is in CF10.
Steps to Reproduce:
<Cfset q = querynew('col1')>
<Cfset queryaddrow(q)>
<Cfset querysetcell(q,'col1','300D')>
<cfdump var="#q#"/>
<cfquery dbtype="query" name="q2">
SELECT col1 FROM q
</cfquery>
Actual Result:
ERROR: The value 300D cannot be converted to a number.
Expected Result:
No Error
Any Workarounds:
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3330734
External Customer Info:
External Company:
External Customer Name: ryanheberly
External Customer Email:
External Test Config: My Hardware and Environment details:Attachments:
Comments: