Hey Steve! thanks but '' produces the same error :-( - James
-----Original Message----- From: Steve Onnis [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 5:30 PM To: CFAussie Mailing List Subject: [cfaussie] RE: Apostrophes in cfsearch maybe '' so * "'Australia''s'" obviously throws an error -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of James Macpherson Sent: Tuesday, 8 July 2003 5:26 PM To: CFAussie Mailing List Subject: [cfaussie] Apostrophes in cfsearch Hey all! was wondering if anyone knows how to escape apostrophes (') in coldfusion mx... all of the documentation I can find seems to suggest that \' should work but it does not... for example, my search critera * "'Australia'" works fine * "'Australia's'" obviously throws an error * "'Australia`'`s'" throws the same error * "'Australia\'s'" throws no errors, but returns no results and it certaily should (for reference the error thrown is coldfusion.tagext.lang.CFSearchTagException: Error # -2 Error E1- 0106 (Query Builder): No topic built.. ) Very annoying :-) Any help much appreciated - James --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
