I am surprised that double quotes should pose any kind of problem; Single-quotes are the real culprit in SQL. Are you sure the problem is with your query and not with the display? You should always use #HTMLEditFormat(myquery.myvalue)# when outputting data from user input in an html page, especially when it is used inside of the value attribute of <input> tags. Maybe you should post the code you're having the truncation issue with.
brendan avery 2.0 - [EMAIL PROTECTED] 310.779.2211 - santa monica, california -----Original Message----- From: ehoma [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 17:51 To: CF-Talk Subject: Double Quotes Hi, I'm have a question about characters like double quotes ("). I am using a form field, textarea, to allow input into a memo field in the database table. If the user enters a double-quotation mark in their text it will truncate the string during the SQL Update command. Is there a simple command that will locate and convert these in a string? Are there other characters that I need to worry about that will cause problems? Thanks, Eric Homa ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
