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(fo rm.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?
[Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect syntax near '000.00'.
73 : UPDATE Donations
74 : Set Amount = #dollarformat(rereplace(fo
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?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That is great!
try using number format instead.