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.
Thanks,
K.
______________________________________________________
Kay Smoljak - HTML/ColdFusion Developer - PerthWeb Pty Ltd
Internet Solutions for your business!
Level 9/105 St George's Tc - Perth - Western Australia
Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007
Visit Perth online! : www.perthweb.com.au
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
