PreserveSingleQuotes

Description

Prevents ColdFusion from automatically "escaping" single quotes contained in variable.

Syntax

PreserveSingleQuotes(variable)

Parameters

Parameter

Description

variable
Variable that contains a string for which single quotes are preserved.

Parameter	Description
variable	Variable that contains a string for which single quotes are preserved.

Usage

PreserveSingleQuotes is useful in SQL statements.

Example

<!--- This example shows the use of PreserveSingleQuotes --->
<html>
<head>
<title> PreserveSingleQuotes Example </title>
</head>

<basefont face = "Arial, Helvetica" size = 2>
<body bgcolor = "#FFFFD5">

<H3>PreserveSingleQuotes Example</H3>
<P>This is a useful function for creating lists of information to 
return from a query. In the following example, we pick the list 
of Centers in Suisun, San Francisco, and San Diego, using the SQL
grammar IN to modify a WHERE clause rather than looping through 
the result set after the query is run.

<cfset List = "'Suisun', 'San Francisco', 'San Diego'">

<cfquery name = "GetCenters" datasource = "cfsnippets">
  SELECT Name, Address1, Address2, City, Phone
  FROM Centers
  WHERE City IN (#PreserveSingleQuotes(List)#)
</cfquery>

<P>We found <cfoutput>#GetCenters.RecordCount#</cfoutput> records.
<cfoutput query = "GetCenters">
<P>#Name#<BR>  
#Address1#<BR>
<cfif Address2 is not "">#Address2#</cfif>
#City#<BR>
#Phone#<BR>
</cfoutput>
</body>
</html>