Status/Resolution/Reason: To Fix//
Reporter/Name(from Bugbase): Earl Schellhous / Earl Schellhous (Earl Schellhous)
Created: 07/07/2015
Components: Database
Versions: 11.0
Failure Type: QA Work Item
Found In Build/Fixed In Build: CF11_Final /
Priority/Frequency: Normal / All users will encounter
Locale/System: English / Linux OracleLinux 6
Vote Count: 0
Problem Description: A number saved to the database as 22.22 will display on cfoutput or cfdump as 22.21999999999999. Looking at it in the database in Toad it is still 22.22 until I put to_char() around the column, then I get the 22.21999999999999.
Steps to Reproduce:
create a table in oracle with a column of type NUMBER
use an insert statement in cfquery that has <cfqueryparam cfsqltype="CF_SQL_FLOAT" value="#somevar#"> where somevar is equal to 22.22
make a page with a select statement for the column and output the column value to a browser
Actual Result:
22.21999999999999
Expected Result:
22.22
Any Workarounds:
I was able to fix this by changing:
<cfqueryparam cfsqltype="CF_SQL_FLOAT" value="#somevar#">
to:
<cfqueryparam value="#somevar#">
(remove the cfsqltype attribute)
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 4017640
Reason: BugVerified
External Customer Info:
External Company:
External Customer Name: Earl
External Customer Email:
External Test Config: My Hardware and Environment details:
Oracle Linux 6
Oracle 11g 11.2.0.2.0
Server Product ColdFusion
Version 11,0,04,293328
Tomcat Version 7.0.54.0
Edition Developer
Operating System UNIX
OS Version 3.8.13-55.1.5.el6uek.x86_64
Update Level opt/coldfusion11/cfusion/lib/updates/chf11000004.jar
Adobe Driver Version 5.1.3 (Build 000094)Attachments:
Comments: