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]
- Inserting Comma in DB Shahzad.Butt
- Re: Inserting Comma in DB Thomas Chiverton
- RE: Inserting Comma in DB Josh Remus
- RE: Inserting Comma in DB Tangorre, Michael
- RE: Inserting Comma in DB John Beynon
- RE: Inserting Comma in DB Marlon Moyer
- RE: Inserting Comma in DB Pascal Peters
- RE: Inserting Comma in DB John Beynon
- RE: Inserting Comma in DB Jason.Gulledge
- RE: Inserting Comma in DB Pascal Peters
- RE: Inserting Comma in DB Shahzad.Butt
- Re: Inserting Comma in DB Thomas Chiverton