User Guide

640 Chapter 3: ColdFusion Functions

This function ensures that ColdFusion evaluates the code as follows:

'1', '2', '3'

Example

<h3>PreserveSingleQuotes Example</h3><p>This is a useful function for

creating lists of information to return from a query. In this 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.

SELECT Name, Address1, Address2, City, Phone

FROM Centers

WHERE City IN (#PreserveSingleQuotes(List)#)

</cfquery>

<p>We found <cfoutput>#GetCenters.RecordCount#</cfoutput> records.

#Address1#<br>

<cfif Address2 is not "">#Address2#

</cfif>

#City#<br>

#Phone#<br>

</cfoutput>