I thank you for all the help with the null numbers. I still really hate
those things :)
Anyhow, I'm now on to searching for everything I had entered. And I have it
set up so that it does your basic searches.
My problem is this...
<cfif findnocase(' ',keyword)>
<!--- Search for Everything on Each side of space --->
<cfloop list="#keyword#" index="keywords" delimiters=' '>
<cfquery datasource="#db#" name="search_results">
select *
from table
where name LIKE '%#keywords#%'
</cfquery>
<cfoutput query="search_results">#item1# - #item2#<br></cfoutput>
</cfloop>
I get back High School, High School, High Jump. Even though there's only
one High School and one High Jump in the db.
It finds it once for High and then again for School.
How do I avoid this?
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
