Link to home
Start Free TrialLog in
Avatar of JohnLucania
JohnLucania

asked on

dollarformat

Error Executing Database Query.  
[Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect syntax near '000.00'.  


73 :                         UPDATE Donations
74 :                               Set Amount = #dollarformat(rereplace(form.amount,"(\$)|(,)","","all"))#
75 :                         WHERE pledgeID = #getPledge.pledgeID# AND donationID = #getDonations.DOnationID#
76 :                   </cfquery>
77 :                   

--------------------------------------------------------------------------------
 
SQL    UPDATE Donations Set Amount = $3,000.00 WHERE pledgeID = 219 AND donationID = 11676  

How do you correct this?
Avatar of rob_lorentz
rob_lorentz

dollarFormat takes a number string and formats is putting the $ , and . in the number.

try using number format instead.
SOLUTION
Avatar of rob_lorentz
rob_lorentz

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of JohnLucania

ASKER

That is great!