Question
Precision Problem with CFQUERY
I have a column in Oracle which is a Number with precision
10, and scale 4.
Everytime I select anything from there from CF, it is displaying all 4 decimals.
Say the number "1" is in one record, "2.2" is in the second record, "3.0003" is in the third.
when I do a select all in a cfquery, I get:
1.0000
2.2000
3.0003
but if I were to select it in SQLPLUS, I get:
1
2.2
3.003
which is the result I desire. Why is Cold fusion adding zeros to the cfquery? And how can I fix this?
Thanks,
boybles
Everytime I select anything from there from CF, it is displaying all 4 decimals.
Say the number "1" is in one record, "2.2" is in the second record, "3.0003" is in the third.
when I do a select all in a cfquery, I get:
1.0000
2.2000
3.0003
but if I were to select it in SQLPLUS, I get:
1
2.2
3.003
which is the result I desire. Why is Cold fusion adding zeros to the cfquery? And how can I fix this?
Thanks,
boybles
AdChoices