Inside Coldfusion MX

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>