When you do the insert statement use PreserveSingleQuotes(form.textarea) around your value. CF puts escape characters around the single quotes so they don't crash your query. Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, July 08, 2001 8:53 AM Subject: Contents of textarea formfield getting stripped out after quotation mark | I'm having a problem and can't figure out why. | Using Access97 for the backend, I submit a form with a textarea tag. If there | are quotation marks in the textarea tag, everything in the textarea from | where the quotation marks begin is stripped out when the textarea formfield | is inserted into the database. | | Why is everything from the quotation mark on, stripped out upon insert??? | | How can I get that stuff to NOT be stripped out? | | Thanks, | | Jo-Anne Head | [EMAIL PROTECTED] | | Archives: http://www.mail-archive.com/[email protected]/ | Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
