Skip to main content
Participant
June 4, 2009
Question

cfgridcolumn, mask

  • June 4, 2009
  • 1 reply
  • 2159 views

My form is format="flash"

I have not found a solid post with a solution for formatting a gridcolumn type="currency" using the mask="".  What is odd is on the same row from the query one column is great $10.45 and the next column is 10.35000898979.  I dumped the query and the values there are 10.45 and 10.35 .  I tried the mask="$9,999.99"  but is just does $9,9999.9910.35000898979 in the column.  Any suggestions would be welcome.

    This topic has been closed for replies.

    1 reply

    BKBK
    Community Expert
    Community Expert
    August 15, 2009
    and the next column is 10.35000898979.

    Don't you mean the next row? I think the correct requirements for currency display are:

    <cfform format="flash">

    <cfgridcolumn name="someDecimalFloatOrDouble" type="currency" mask="$">