Re: Little help with a query please ... FIXED

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#%

Re: Little help with a query please ... FIXED

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 /