#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    7
    Rep Power
    0

    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. #2
  3. Digitally Challenged
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Posts
    280
    Rep Power
    11
    try using the coldfusion function DollarFormat(number)
    My brain cells are like a storm trooper's armor: useless
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    7
    Rep Power
    0
    Excellent! That worked perfectly.

    Now, what about the "squiggly lines"?

    Anyone??
  6. #4
  7. Digitally Challenged
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Posts
    280
    Rep Power
    11
    could you post your code, as well as the resulting output that creates the 'squigly lines'?
    My brain cells are like a storm trooper's armor: useless

IMN logo majestic logo threadwatch logo seochat tools logo