Les, That looks good. Did you try running that directly in your database?
While I was looking at your query, I thought I would toss out how I would have written it, which removes an extra conditional and an extra variable: SELECT id_page, headline, content, section FROM pages WHERE section <> 'news' <cfif ListLen(myLIST) gt 1> AND ( <cfloop list="#mylist#" index="i"> 1 = 0 or headline LIKE <cfqueryparam value="%#i#%" cfsqltype="cf_sql_varchar"> or content LIKE <cfqueryparam value="%#i#%" cfsqltype="cf_sql_varchar"> </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> Steve >On 5/4/2011 9:11 PM, Greg Morphis wrote: >> >> Take your query and wrap it in a cfoutput tag instead of cfquery. >> Remove the cfqueryparams and just have the variables. > >That's this: > >WHERE section <> 'news' >AND ( headline LIKE '%bob%' >or content LIKE '%bob%' OR headline LIKE '%robert%' >or content LIKE '%robert%' ) > > >...or,when entering only one variable (and this is working) > >WHERE section <> 'news' >AND ( headline LIKE '%bob%' >or content LIKE '%bob%' ) > > > > >Query is: > > 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:344249 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm