Optionally, I think cfqueryparam works too, but I haven't tested that in a while.

-----Original Message-----
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: Friday, April 23, 2004 9:21 AM
To: CF-Talk
Subject: RE: Inserting Comma in DB

PreserveSingleQuotes() ?

Mike

> -----Original Message-----
> From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
> Sent: Friday, April 23, 2004 10:18 AM
> To: CF-Talk
> Subject: Inserting Comma in DB
>
> Hi
>
>  
>
> <CFSet myComments = "It wasn't the best solution">
>
>  
>
> INSERT INTO tb_JQoS_Results
>
>                         (Comments)
>
>  
>
> Values (' #myComments# ')
>
>  
>
> It gives error because of the comma. How can we make it working?
>
>  
>
>  
>
> Thanks
>
> Shaz
>
>
>
> **********************************************************************
> This email and any files transmitted with it are confidential
> and intended solely for use by the individual or entity to
> whom it is addressed. If you have received this e-mail in
> error, kindly notify [EMAIL PROTECTED] or call
> +44 1992 701 704. Unless stated otherwise, please note
> that any views or opinions expressed in this e-mail are
> solely that of the author and are not necessarily of JJ Fast
> Food Distribution Limited. The company can not assure that
> the integrity of this communication has been maintained nor
> that it is free of errors, virus, interception or
> interference. The company accepts no liability for any damage
> caused by this email. JJ Fast Food Distribution Limited
> reserves the right to monitor and or record e-mail without
> prior notification.
> **********************************************************************
>
>
>
>
  _____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to