Please excuse my inaccurate response, I wasn't fully thinking...
Hatton
> -----Original Message-----
> From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 10, 2001 10:30 AM
> To: CF-Talk
> Subject: RE: insert problem
>
>
> 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
