Strong Data typing observed in MX7

[Joedh]

:Q

I was shocked to see details realized by CFquery today. We recently upgraded
to MX7 in our production area. Still not sure it is MX7 but no other changes
have been made to my knowledge. Maybe we missed this in testing but a user
found a bug today. The bug was a javascript procedure that could not handle
numbers with greater than 2 decimals. What we discovered is that a CFquery was
returning decimals to match the Oracles database type. Example Number(15,4) or
Number(22,10)
Even though the data stored was 6 and 30.12 the cfoutput result was 6.0000 or
30.1200000000.

This was resolved by placing an Oracle function round("column", 2) on the
fields affected.

But this stuns me to see this kind of binding with CF. I have never seen this
before. Typically the results returned are simple text with no strong data
types. I am not sure if this something new with MX7. Maybe it is the database
connection. We are current no using any special thin client just CF Oracle DB
connection.

[BKBK]

Just to be sure, I would install the [url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_17883[/url].

[Joedh]

Applied the following patches but still no resolution. I finding more places
where decimals are showing up. So it is becoming a bit of a pain. I still do
not understand why CF is doing this.

Updated DataDirect JDBC drivers (version 3.5) ( Article 42dcb10a ) - This
one I am not sure I applied correctly. I can not find the DLL file it says to
upgrade. (DDJDBCAuth.DLL.)

Hot fix available for JRun4 Updater 6, IIS 6.0 redirect response truncation (
Article 5c9389c8 )

ColdFusion MX 7.0.1 cumulative hot fix 1 ( Article aae43964 )