PreserveSingleQuotes

"-->

 PreserveSingleQuotes (variable) 

Description

Prevents ColdFusion from automatically escaping single quotation-mark characters that are contained in a variable. ColdFusion does not evaluate the argument.

Example

 <cfset exampleList = "'Blender', 'Food Processor', 'Mixer', 'Toaster'">  <cfquery name = "exampleQuery" datasource = "exampleDB">    SELECT ProductName, SKU, InStock    FROM Products    WHERE ProductType IN (#PreserveSingleQuotes(exampleList)#)  </cfquery>