dollar sign doesn't work

Hi, I have a problem like this. I created a table called price_range. There is only one field in that table with data type currency. The reason I created that table was because I wanted to create a list box so that user can select a price from the list box. When I created a coldfusion using cfform
and cfselect, the price value in the list box has 4 zeros after the decimal point and no dollar sign at the beginning. Does anyone know how to show the dollar sign at the beginning of each value in the list box like this: $125,000

Thanks

Use the dollarFormat() function.

I tried it before, but it displayed an error message. Do you mean where to put the dollar format?

Since you are using CFSELECT you might not be able to use dollarFormat(). Depending on what database you are using, you should also be able to get the value formatted with a dollar sign right from the database. Try looking for a function for your RDBMS that will let you format the field within your select statement.

For example, in Oracle you would do this in your select statement:

TO_CHAR(price_range, '$999,999,999.99') as price_range