tracker issue : CF-3330734

select a category, or use search below
(searches all categories and all time range)

Dynamically Typed Queries with '300D' in the first row.

| View in Tracker

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

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:



This fix will be available in the next major release.
Comment by Nimit S.
18089 | February 09, 2014 06:14:04 AM GMT