It did work!
Thanks Craig
--- Craig Fisher <[EMAIL PROTECTED]> wrote:
>
> This will work:
>
> <CFQUERY name="GetResults" dataSource="W**">
> SELECT *
> FROM Tasks
> WHERE Archive = 0
> #PreserveSingleQuotes(type_sql)#
> </CFQUERY>
>
> -------------------------------------
> From the docs:
>
> PreserveSingleQuotes
>
> Prevents ColdFusion from automatically "escaping"
> single quotes contained in
> variable.
>
> Syntax
>
> PreserveSingleQuotes(variable)
>
> variable
>
> Variable containing the string for which single
> quotes are preserved.
>
> Usage
>
> PreserveSingleQuotes is useful in SQL statements.
>
> -------------------------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
