Summary

This lesson described how to build a search tool that dynamically builds a WHERE clause of the SQL SELECT statement using cfif and cfset tags. To ensure that the SQL statement remains intact, you used the PreserveSingleQuotes CFML function.