Thanks for the try, but it didn't work. Does anybody know how ColdFusion escapes a single quote when inserting/updating a database?
- Matt Small -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 11:52 AM To: CF-Talk Subject: RE: Crosspost: Escaping single quotes Most RDBMS's escape ' as '', so : #replace(str, "'", "''", "all")# --- Billy Cravens -----Original Message----- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 10:56 AM To: CF-Talk Subject: RE: Crosspost: Escaping single quotes No, that preserves single quotes. I want to escape single quotes. Thanks, Matt Small -----Original Message----- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 11:32 AM To: CF-Talk Subject: Re: Crosspost: Escaping single quotes Isn't there a function (PreserveSingleQuotes) that does this? At 11:38 AM 4/12/2002 -0400, you wrote: >Hi everybody, > I'm having a problem with an update to a table - the problem is >when I want to update or insert the string "Teacher's Group". CF throws >an error at me when I try this. I know that CF usually escapes the >single quote, but it's not in this case. I know I saw a post with on >this list or CFDJList about there being a bug with escaping single >quotes >in CF4.5. Anybody know how can I make CF escape the single quote for >insertion into my table? Thanks > >Matt Small > > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
