Hi Brett, I am having problems with CFSEARCH criteria as per email subject.. shoulda made that clearer in my explaination ;-) Made sense to me!
preserve single quotes doesn't seem to make a difference one way or another - James -----Original Message----- From: Brett Payne-Rhodes [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 5:35 PM To: CFAussie Mailing List Subject: [cfaussie] Re: Apostrophes in cfsearch Hi James, Is this in an SQL statement, or a Verity search, or what? Whatever it is you might try the 'preserveSingleQuotes' function. Brett B) James Macpherson wrote: > 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/ > -- Brett Payne-Rhodes Eaglehawk Computing t: +61 (0)8 9371-0471 f: +61 (0)8 9371-0470 m: +61 (0)414 371 047 e: [EMAIL PROTECTED] w: www.ehc.net.au --- 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/
