Add bolean logic to a simple search

[Conti]

The following works good with just one term criteria:

A.TITLE LIKE <cfqueryparam cfsqltype="cf_sql_varchar" value="%#criteria#%">
OR A.SUBTITLE LIKE <cfqueryparam cfsqltype="cf_sql_varchar"
value="%#criteria#%">
OR A.ABSTRACT LIKE <cfqueryparam cfsqltype="cf_sql_longvarchar"
value="%#criteria#%">
OR A.CONTENT LIKE <cfqueryparam cfsqltype="cf_sql_longvarchar"
value="%#criteria#%">

Please advise the best approach so that multiple terms may be used.
Thank you very much.
ContiW

[Neculai Macarie]

> The following works good with just one term criteria:

>
> A.TITLE LIKE <cfqueryparam cfsqltype="cf_sql_varchar"

value="%#criteria#%">

> OR A.SUBTITLE LIKE <cfqueryparam cfsqltype="cf_sql_varchar"
> value="%#criteria#%">
> OR A.ABSTRACT LIKE <cfqueryparam cfsqltype="cf_sql_longvarchar"
> value="%#criteria#%">
> OR A.CONTENT LIKE <cfqueryparam cfsqltype="cf_sql_longvarchar"
> value="%#criteria#%">

Treat the criteria as a list with space as delimiter:

( 1 = 1
<cfloop list="#criteria#" delimiters=" " index="i">
AND A.TITLE LIKE <cfqueryparam cfsqltype="cf_sql_varchar" value="%#i#%">
</cfloop>
)
OR
( 1 = 1
<cfloop list="#criteria#" delimiters=" " index="i">
A.SUBTITLE LIKE <cfqueryparam cfsqltype="cf_sql_varchar" value="%#i#%">
</cfloop>
)
......

--
<mack />

[Conti]

Cool, Neculai !

Now, if spaces between terms where ANDs and commas where ORs?
(Please don't sweat over it. Just if you have something handy).
Thank you very much.
ContiW