On Sat, May 22, 2010 at 11:46 PM, Les Mizzell wrote: ... > lst.srchTHS won't ever be more then three to five words or so, but I > wish I could figure a way to use cfqueryparam list="yes" instead of a > loop...
I think you might be able to concat the fields and then use a regex search, if the DB supports it, but the performance tradeoff might suck. Then there's stored procedures... you could offload the processing to the DB... :den -- It is not necessary that whilst I live I live happily; but it is necessary that so long as I live I should live honourably. Immanuel Kant ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333933 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm