Hello, I was able to figure out my problem. Sorry for the inconvenience. John ------- Start of forwarded message ------- Subject: Updating Dollarformat value To: [EMAIL PROTECTED] From: [EMAIL PROTECTED] Date: 22 Jan 2001 10:22:02 PST Hello, I am having a problem updating the value of a dollarformat field. For example, if the value returned from SQL Server is $1,012.60, the field will not update when submitted even though I haven't changed the value. It seems when I remove the comma, the update will work. However, for values less than $1,000.00 the updates will work. Here is the SQL SET : strRepGoalGrossSales = convert(money,#form.RepGoalGrossSales#), and this is the input field: value="#DollarFormat(RepGoalGrossSales)#" I have tried using numberformat with a mask and have been unsuccessful. I am running SP3 on SQL Server. Any help would be appreciated. TIA John Visit www.cfworkshop.com Find the best deals on the web at AltaVista Shopping! http://www.shopping.altavista.com ------- End of forwarded message ------- Visit www.cfworkshop.com Find the best deals on the web at AltaVista Shopping! http://www.shopping.altavista.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
