Re: SQL Query Headache...

[Steve Reich]

> Try to use PreserveSingleQuotes function:
> 
> .....
> WHERE messages.parent = 0 AND messages.active = 1
> #PreserveSingleQuotes(KeyWords)#
> .....
> 
> Marian


That was it! Thank you very much! 

Steve

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists