within cfquery. But in any case, use <cfqueryparam>
Pascal
> -----Original Message-----
> From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
> Sent: vrijdag 23 april 2004 16:18
> 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]

