CFDJ Vol. 3 , Issue 3- pg.42
Ask The Training Staff, by Bruce Van Horn 

Listing 1
<CFQUERY NAME="qGetEmp" DATASOURCE="Employees">
SELECT LastName, FirstName
FROM   Employees
WHERE LastName LIKE '#Form.LastName#%'
</CFQUERY>



Listing 2
<CFQUERY NAME="qGetEmp" DATASOURCE="Employees">
SELECT LastName, FirstName
FROM   Employees
WHERE Soundex(LastName) = Soundex('#Form.LastName#')
</CFQUERY>



Listing 3
<!--- Time a block of code --->
<CFSET tickBegin = GetTickCount()>
YOUR CODE GOES HERE
<CFSET tickEnd = GetTickCount()>
<CFSET ExecuteTime = Variables.tickEnd - Variables.tickBegin>


<!--- Report --->


<CFOUTPUT>
The execution time for the above code was: #Variables.ExecuteTime# Milliseconds
</CFOUTPUT>



Listing 4
<CFQUERY NAME="qGetRandBeans" DATASOURCE="Coffee_Valley" CACHEDWITHIN="#CreateTimeSpan(0,0,30,0)#">
       SELECT Bean_ID, Bean_Name
       FROM   Beans
</CFQUERY>
<CFSET MyList = "">
<CFLOOP CONDITION="ListLen(Variables.MyList) LT 4">
       <CFSET PickOne = RandRange(1,qGetRandBeans.RecordCount)>
       <CFIF NOT ListFind(Variables.MyList,Variables.PickOne)>
               <CFSET MyList = ListAppend(Variables.MyList,Variables.PickOne)>
       <CFOUTPUT>
       #qGetRandBeans.Bean_Name[Variables.PickOne]#<BR>
       </CFOUTPUT>
       </CFIF>
</CFLOOP>