Listing 1:
<!--- my original suggestion --->
<CFQUERY NAME="qSearch" DATASOURCE="#Request.DSN#">
SELECT * FROM Table
WHERE Name = 'PlaceHolderText'
<CFLOOP LIST="#Form.SearchText#" INDEX="SearchItem">
OR Name LIKE '%#Trim(SearchItem)#%'
</CFLOOP>
</CFQUERY>

Listing 2:
<!--- a better way to handle dynamic ORs --->
<CFQUERY NAME="qSearch" DATASOURCE="#Request.DSN#">
SELECT * FROM Table
WHERE 0 = 1
<CFLOOP LIST="#Form.SearchText#" INDEX="SearchItem">
OR Name LIKE '%#Trim(SearchItem)#%'
</CFLOOP>
</CFQUERY>

Listing 3:
<!--- a better way to handle dynamic ANDs --->
<CFQUERY NAME="qSearch" DATASOURCE="#Request.DSN#">
SELECT * FROM Table
WHERE 0 = 0
<CFLOOP LIST="#Form.SearchText#" INDEX="SearchItem">
AND Name . . . 
</CFLOOP>
</CFQUERY>

Listing 4: 
<CFIF FileExists("D:\cfusion\log\mail.log")>
<CFFILE ACTION="MOVE"
SOURCE="d:\cfusion\log\mail.log"
DESTINATION="d:\inetpub\netsite\htdocs\mail.log">
<CFHTTP URL="http://www.netsitedynamics.com/mail.log"
METHOD="GET"
NAME="qMailLog"
TEXTQUALIFIER=""""
DELIMITER=","
RESOLVEURL="false"></CFHTTP>
<CFOUTPUT QUERY="qMailLog">
<CFSET Start = FindNoCase("No connection to mail server",qMailLog.Message)>
<CFIF Start gt 0>
<CFSET FileStart = FindNoCase("d:\CFUSION\Mail\undelivr",
qMailLog.Message)>
<CFSET FileName1 = Mid(qMailLog.Message,FileStart,(Len(qMailLog.
Message)-FileStart))>
<CFIF FileExists(FileName1)>
<CFSET FileName2 = ReplaceNoCase(FileName1,"d:\CFUSION\Mail\undelivr","d:\CFUSION\Mail\spool")>
<CFFILE ACTION="MOVE"
SOURCE="#FileName1#"
DESTINATION="#FileName2#">
</CFIF>
</CFIF>
</CFOUTPUT>
Yes, moved files
<CFELSE>
No files exist
</CFIF>

Listing 5:
<CFQUERY NAME="qGet10Prods" DATASOURCE="#Request.DSN#">
SELECT TOP 10 ProductID, Cat_No, ProductName, Description, List_Price
FROM Products 
ORDER BY NewID()
</CFQUERY>