Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Unanswered: Quote Marks on Insert

    I'm a bit new to mySQL and having a problem with quote marks. I'm inserting into a table via a ColdFusion form page, and data containing quote marks seem to not be inserted. I don't get an error -- all subsequent fields fill up fine -- but the quoted data seem to get truncated. For example:

    This is a "long" book.

    gets added as:

    This is a

    Any thoughts? I've tried escaping with a backslash as well as double-quotes.

    Thanks in advance...

    - Tom Tedeschi

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    can you show the exact CFQUERY and the INSERT statement? | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts