Using the DollarFormat Function

Use the DollarFormat( ) function to format values with a dollar sign, a thousand separator, and 2 decimal places. Its syntax is:

DollarFormat(NumericValue)

• Place a NumericValue to format within the function's parenthesis ( ).
• NumericValue may be a fixed or variable value.
• Reference the function anywhere on a ColdFusion page.
• When referencing the function within a CFOUTPUT block, surround the entire function with pound signs (#).

This tells ColdFusion to return function results rather than the function name to the browser.

DollarFormat function usage examples

The two code sets below display $23,333.44 in a browser:

<CFOUTPUT>
    #DollarFormat(2333344)#
</CFOUTPUT>

• DollarFormat( ) formats a fixed value for display.
• Surround the entire function with pound signs (#) for immediate output.

<CFSET Salary=DollarFormat(2333344)>
<CFOUTPUT>
    #Salary#
</CFOUTPUT>

• DollarFormat( ) formats a fixed value for the Salary variable.
• Surround the Salary variable with pound signs (#) for display.

The code below formats the Salary column data that was returned from a query performed earlier on the same page:

<CFOUTPUT QUERY="EmpList">
    #DollarFormat(Salary)#<BR>
</CFOUTPUT>

• DollarFormat( ) formats a variable for display.
• Surround the entire function with pound signs (#) for immediate output.

To format currency for display:

1. Return to the page that you're building.
2. Format the Salary query data using the DollarFormat() function within the existing TD block:

#DollarFormat(Salary)#

3. Save the file.
4. View the page in a browser.

The Salary is formatted for page display.

Click here to see how the page should look at this time.

Click here to see the code behind the scenes.

Note:

The navigation links will not work at this time.

Copyright © 1999, Allaire Corporation. All rights reserved.