Old CF Bug Fixed / single quote issue in complex string functions...
An old bug involving the use of complex string functions inside of queries with values having single quotes has been fixed!
http://www.macromedia.com/support/coldfusion/ts/documents/quotes_hotfix.htm