Boolean Searches

[freezer9]

I am trying to implement a boolean type search . The current search that I have
searches for exact matches, if the input has multiple words. I want the search
to take the multiple words and ouput all those records that have all those
words, irrepective of the order in which they occur in each record. Here's the
code that I have - can anyone spot a mistake, because it is not working, and it
is too late and I am getting a headache ;-)

<cfif search_category is "DESCRIPTION">
<cfset temp_query = Replace(TRIM(UCASE(query))," ","+","ALL")> <!-- Replace
all spaces with + to creat a list-->
<cfif ListLen(temp_query,'+') gt 1> <!-- Check to see List has more than one
element -->
<cfloop index="i" from="1" to="#ListLen(temp_query,'+')#">
<cfset temp_query_i = ListGetAt(temp_query,i,'+')>
</cfloop>
</cfif>
</cfif>

<cfif search_category is "DESCRIPTION">
<cfif ListLen(temp_query,'+') gt 1>
<cfloop index="i" from="1" to="#ListLen(temp_query,'+')#">
upper(DESCRIPTION) like '%#TRIM(UCASE(temp_query_i))#%' <cfif i lt
ListLen(temp_query,'+')>AND</cfif>
</cfloop>
<cfelse>
upper(DESCRIPTION) like '%#TRIM(UCASE(query))#%'
</cfif>
</cfif>

[freezer9]

Never mind - got a simple solution from [url]http://tutorial234.easycfm.com/[/url] Works
like a charm! <CFQUERY NAME='searchresults' DATASOURCE='yourdatasource'>
SELECT * FROM table WHERE 0=0 AND ( <cfloop index='i'
list='#form.searchkeyword#' delimiters=' '> <cfoutput>fieldname LIKE
'%#i#%' AND </cfoutput> </cfloop> '%%') </CFQUERY>