tracker issue : CF-3043979

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

Bug 87054:(Watson Migration Closure)CFQUERYPARAM is not allowing users to define scale="0" even though scale="0" is the default

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): Henry Ho / Henry Ho (Henry Ho)

Created: 08/19/2011

Components: Database, CFQuery

Versions: 9.0.1

Failure Type: Unspecified

Found In Build/Fixed In Build: 0000 /

Priority/Frequency: Minor / Some users will encounter

Locale/System: English / Platforms All

Vote Count: 0

Listed in the version 2016.0.0.297996 Issues Fixed doc
Verification notes: verified_fixed on August 07, 2017 using build 2016.0.01.298513 
Problem:

CFQUERYPARAM is not allowing users to define scale="0" even though scale="0" is the default.
Method:

<cfqueryparam value="123" cfsqltype="cf_sql_decimal" scale="0">
Result:

The value of the SCALE attribute is invalid. The value specified, 0.0, must be greater than 0.0.

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

Watson Bug ID:	3043979

External Customer Info:
External Company:  
External Customer Name: Henry Ho
External Customer Email: 237A22C24921EDF5992015B9
External Test Config: 08/19/2011

Attachments:

Comments:

Verified this is fixed in CF2016 Update 1 (build 2016.0.01.298513). Thanks!, -Aaron
Comment by Aaron N.
21008 | August 07, 2017 06:56:00 AM GMT