In ColdFusion, is there a numberFormat() mask to drop the decimal if it is 0?

coldfusion coldfusion-9 number-formatting
eterps picture eterps · Jul 5, 2012 · Viewed 10.4k times · Source

I'm trying to format numbers so that 2 decimal places show up, unless it is a whole number - then I don't want a decimal point to show. I've tried 0.00, _.__, 9.99 and several combinations. Is there a mask for the numberFormat function that can get this result?

Answer

Henry picture Henry · Jul 5, 2012 
<cfif int(x) eq x>
  #int(x)#
<cfelse>
  #DecimalFormat(x)#
</cfif>

Related questions

displaying an ajax response with jquery

I have a Coldfusion cfc that queries a database for data. I would like to call that cfc and display the ajax response within a div. Eventually I would like to format the response with html. Currently I am having …

Read More
illegal xml character on SQL Insert

I am trying to insert the following string into an sql xml field <?xml version="1.0" encoding="UTF-8"?> <Response> <Ip>x.x.x.x</Ip> <CountryCode>CA</CountryCode> <…

Read More
ColdFusion inital value of currentrow when no index specified in cfloop

I am converting a ColdFusion application to C# (I'm a CF n00b). I have a script that performs a cfquery and then cfloop's through the results, and it appears to be trying to compare the current row to its …

Read More