i'm trying to same a number that has been formatted as dollar amount
if i have an amount that is $1,110.00 it's telling that i have an error
i'm pretty sure that it is because i'm trying to save and the number is
being placed with a comma in it. how can i work around this.
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 9: Incorrect syntax near
'110.00'.
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (367:2) to (367:63).
Date/Time: 05/10/01 10:08:17
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists