|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Be the architects of evolution and help create the mobile internet future. It’s your move---enter to win here! |
|
#1
|
|||
|
|||
|
Zeros being dropped when displayed
My host provider recently upgraded from CF5 to CFMX and ever since then, the ending zeros on my prices have not been displaying. For example, I have 1.40 in the MySQL database and when I display this price using CFML it displays "1.4" If the price ends with anything other than zero, that number will display. It's only a problem when the number ends in zero. My prices are stored in the database as decimal (10,2).
Also, I used bullets to seperate text, and after the move to CFMX my bullets are showing up as "squiggly lines" (sorry, I don't know how else to describe them). Anyone have a solution to this problem? |
|
#2
|
||||
|
||||
|
try using the coldfusion function DollarFormat(number)
__________________
My brain cells are like a storm trooper's armor: useless |
|
#3
|
|||
|
|||
|
Excellent! That worked perfectly.
Now, what about the "squiggly lines"? Anyone?? |
|
#4
|
||||
|
||||
|
could you post your code, as well as the resulting output that creates the 'squigly lines'?
|
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > ColdFusion Development > Zeros being dropped when displayed |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|