Replace(#form.textfield#, "'", "'") This is untested.
Adaryl "Did you reboot?" Wakefield Aviator by passion Programmer by sheer force of will ----- Original Message ----- From: "Kristi J. Bohling" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 25, 2004 12:06 PM Subject: [KCFusion] single quotes in text answers > We have a text entry area where users can enter a short answer. They are > including single quotes in their answer. This is causing an issue when > trying to submit this data to the database... it is hitting the single > quote, and is acting as if this is the end of the text string to be entered. > Anyone have a quick fix or a function that I missed? Kristi > > > > ========================================================= > Kansas City ColdFusion User Group's website & listserv is > hosted through the generous support of Clickdoug.com > To send email to the list, email [EMAIL PROTECTED] > To (un)subscribe, email [EMAIL PROTECTED] with your request. > For hosting solutions http://www.clickdoug.com > Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1. > ====================================================== > ========================================================= Kansas City ColdFusion User Group's website & listserv is hosted through the generous support of Clickdoug.com To send email to the list, email [EMAIL PROTECTED] To (un)subscribe, email [EMAIL PROTECTED] with your request. For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1. ======================================================
