displaying a minus dollar amount

[HandersonVA]

I set the price field as money data type on ms sql 2k server but I want to display a money value with a dollar sign as an output.
i think i only need to insert into database w/o dollar sign when I pass a form value into database. how can i handle this situation?

[Dan_Bracuk · Accepted solution]

If it were my database, I would use a numeric datatype for my price. I don't know how mssql works, but if you can't do math with a money datatype, you have a limitation. To display the price, I would do something like this:

<cfoutput>
$#price#

[terryt]

Use numeric value in database instead of currency

2) then on output use:

#dollarformat(price)#

there are a couple of other options i believe

#dollarformat(price,$_______.__)#