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/
