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 <[email protected]> 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
