On 5/4/2011 8:15 PM, Greg Morphis wrote: > > the double quotes? > like '%bob%' or '%ted%'
That's just in the outputted version. I've rewritten it again though. Output is now: WHERE section <> 'news' AND ( headline LIKE '%barnett%' OR content LIKE '%barnett%' OR headline LIKE '%shale%' OR content LIKE '%shale%' ) SELECT id_page, headline, content, section FROM pages WHERE section <> 'news' <cfif ListLen('#myLIST#') gt 1> AND ( <cfloop list="#mylist#" index="i"> <cfset #thisROW# = #thisROW# + 1 /> headline LIKE <cfqueryparam value="%#i#%" cfsqltype="cf_sql_varchar"> or content LIKE <cfqueryparam value="%#i#%" cfsqltype="cf_sql_varchar"> <cfif #thisROW# LT #listCOUNT#> OR </cfif> </cfloop> ) <cfelse> AND ( headline LIKE <cfqueryparam value="%#req.cleanerINPUT#%" cfsqltype="cf_sql_varchar"> or content LIKE <cfqueryparam value="%#req.cleanerINPUT#%" cfsqltype="cf_sql_varchar"> ) </cfif> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344242 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm