Hello-
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

can you show the exact CFQUERY and the INSERT statement?