<cfloop index="URL.SEARCH" list="FORM.SEARCHFORM" delimiters=" "> Products.ProductName LIKE '%#URL.SEARCH#%' OR Companies.CompanyName LIKE '%#URL.SEARCH#%'
</cfloop> Lets say that the there are 2 words in the search technologies and safety. This loop would produce: Products.ProductName LIKE '%technologies%' OR Companies.CompanyName LIKE '%technologies%' Products.ProductName LIKE '%safety%' OR Companies.CompanyName LIKE '%safety%' Notice between the two groups there is a missing 'OR'. William -- William E. Seiter Have you ever read a book that changed your life? Go to: www.winninginthemargins.com Enter passkey: goldengrove Web Developer / ColdFusion Programmer http://William.Seiter.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297931 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
