How about using cfqueryparam?
  -----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