|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
October 6th, 2004, 08:00 AM
|
|||
|
|||
|
Number formatting
Numbers...
If I do a query to the Oracle DB using SQL plus or an other tool, the value returned is 127. When I use CF, the returned value is 127.0000000 (specifically 7 zeros) Is there any specific reason for that? Shall I use round() or any other similar function to solve this annoying but not critical issue? Thanks, Ch.
|
|
#3
October 6th, 2004, 06:17 PM
|
|||
|
|||
|
I'd speculate that the true data type for the field is long or float so that's why you're getting the decimals. You can round it if you are worried, either with CF or right in the SQL query.
__________________
Ask if you have a question, but also help answer questions that you have knowledge of! Thanks, Brian. How to Post a Question in the Forums
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > ColdFusion Development > Number formatting |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
