INSERT INTO tb_JQoS_Results
                         (Comments)

Values (<cfqueryparam cf_sql_type="cf_sql_varchar"
value="#myComments#">)

--
Marlon Moyer, Sr. Internet Developer
American Contractors Insurance Group
phone: 972.687.9445
fax: 972.687.0607
mailto:[EMAIL PROTECTED]
www.acig.com

> -----Original Message-----
> From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
> Sent: Friday, April 23, 2004 9: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