I'm at home on my ipaq so resources are limited but from memory there is a preserveSingleQuotes() function in cf.
Cheers Bruce -----Original Message----- From: "Knott, Brian"<[EMAIL PROTECTED]> Sent: 12/16/03 6:57:35 PM To: "CFAussie Mailing List"<[EMAIL PROTECTED]> Subject: [cfaussie] Inserting a record I'm having a day where my mind has stopped working. I'm trying to insert a record that has a text field. The text has ' in it. Thus the insert fails. I tried to replace the '' with "" but it only partly solves the problem. I think there is a parameter that I can wrap around the text so make a save insert but I can't think of it. Brian Knott --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
