hi,
i normally use this
#RemoveChar(DollarFormat(value), 1, 1)#
> Hi all,
>
> I have a field in an SQL Server database which is of type "money". When I
> display this in a form text box, it defaults to four decimal places. If I
> use moneyformat or decimalformat functions to make it display correctly,
the
> commas and dollar signs cause an error in my update query. Is there some
> other better way of storing money values? Or some other function for
> displaying only two decimal places without commas? I've looked at
> numberformat too but I can't make it do what I want.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
