I know it's late and all but what did you do differently? Here's what you had earlier and looks the same.. lol Like I said.. it's late!
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> On Wed, May 4, 2011 at 9:18 PM, Les Mizzell <lesm...@bellsouth.net> wrote: > > This did the trick: > > > 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:344248 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm