In sql, you must have a single quote surrounding string information. If there is a single quote within the string information itself, ie last_name = 'O'Donnell', then SQL assumes that the string terminates with the second single quote and just the 'O' is inserted. Try doubling the singlequotes in the character string when inserting and then converting to a single quote when retrieving. ie last_name = '#Replace(last_name_var, "'","''","ALL")#' -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 08, 2001 6:53 AM To: CF-Talk 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
