Nope, no comma there, "Incorrect syntax near '110.00'." would lead me to
guess that you have
INSERT INTO Table (Price) values ('#price#')... see if there are quotes
around your field name and if there are, remove them.
HTH
Hatton
> -----Original Message-----
> From: Metzy Martinez [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 10, 2001 1:23 PM
> To: CF-Talk
> Subject: insert problem
>
>
> 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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
