tracker issue : CF-3765663

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

queryExecute ignores scale property in param struct with cfsqltype of 'cf_sql_decimal'

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): John Berquist / John Berquist (John Berquist)

Created: 05/24/2014

Components: Database

Versions: 11.0

Failure Type: Data Corruption

Found In Build/Fixed In Build: CF11_Final /

Priority/Frequency: Major / All users will encounter

Locale/System: English / Windows 8.1/64bit

Vote Count: 0

Listed in the version 11.0.03.292480 Issues Fixed doc 
Running the following code:

queryExecute("UPDATE MyTable SET DecimalColumn = ?", [ { value = 2.45, cfsqltype = 'cf_sql_decimal', scale = 2 } ], { datasource = "mssql" } );

results in a value of 2.00 in the database and not the expected 2.45

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3765663

External Customer Info:
External Company:  
External Customer Name: jberquist
External Customer Email:  
External Test Config: CF11 Express running on Ubuntu 12.04 connecting to a MS SQL datasource.

Attachments:

Comments:

I've verified this is fixed in CF11 Update 3. QueryExecute() honors scale and sends 2.45 to the db for both cf_sql_decimal and cf_sql_numeric. Thanks!, -Aaron
Comment by External U.
12035 | November 05, 2014 05:21:27 PM GMT