Here are some searches I ran
sport
sport and eeg
sport or eeg
sport -department
sport -department eeg
sport -department +eeg
associated cognitive
"associated cognitive"
I didn't put the parens in the search criteria, I just used them here to
denote the actual search criteria I used.
(-department) didn't exclude records with the word in it but
(sport -jessica) did exclude the one record with the word jessica in it when
I searched for sport
The search for
(sport and eeg) returned many records that had neither word in them (I
searched by bio on all of them)
Same thing with (sport or egg)
Same with ("sport" and "eeg")
Same with ("sport" or "eeg")
You also have some unicode characters in the displayed text. Example: search
the word (home) and look at the last sentence in the first result
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-----Original Message-----
From: Daniel Kessler [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 11, 2005 9:01 AM
To: CF-Talk
Subject: google-search 2
As y'all have read, I'm trying to replicate a google-like search on
our database. I think that I have the CF and DB (Oracle) logic
worked out but I'd like someone else to look it over and see if it's
right. I want to search the same way that google does since most
people are used to that. I want words separated by spaces, quoted
text (a phrase) treated as a single word, + meaning that it must have
the word and - that it must not contain the word.
Here's the search page which allows for a search of a few different
columns:
http://hhp.umd.edu/people/people_search.cfm
and here's the code that I use (and any improvements are welcome):
<!---
before this, I make the three arrays described here:
- search_ar: the OR search items
- search_must: the AND "must contain" items, designated
as + before the word
- search_not: the items that "must not contain" in the
returned results, designated as minus before the word
--->
<CFQUERY NAME="people_search" DATASOURCE="dpch">
SELECT
id,fname,lname,type,title,dept,phone,location,email,summary,imagePath,li
nk
FROM PEOPLE
WHERE
<cfloop from="1" to="#arrayLen(search_ar)#" index="ii">
UPPER(#PreserveSingleQuotes(the_search_column)#)
LIKE UPPER('%#search_ar[ii]#%')
<cfif ii LT arrayLen(search_ar)>OR</cfif>
</cfloop>
<cfif arrayLen(search_ar) GT 0 AND arrayLen
(search_must) GT 0>AND</cfif>
<cfif arrayLen(search_must) GT 0>
(
<cfloop from="1" to="#arrayLen(search_must)#"
index="jj">
UPPER(#PreserveSingleQuotes
(the_search_column)#) LIKE UPPER('%#search_must[jj]#%')
<cfif jj LT arrayLen(search_must)>AND</cfif>
</cfloop>
)
</cfif>
<cfif (arrayLen(search_must) GT 0 OR (arrayLen
(search_ar) GT 0 AND arrayLen(search_must) EQ 0)) AND arrayLen
(search_not) GT 0>AND</cfif>
<cfif arrayLen(search_not) GT 0>
(
<cfloop from="1" to="#arrayLen(search_not)#"
index="kk">
UPPER(#PreserveSingleQuotes
(the_search_column)#) NOT LIKE UPPER('%#search_not[kk]#%')
<cfif kk LT arrayLen(search_not)>AND</cfif>
</cfloop>
)
</cfif>
<!--- --->
AND status = 'active'
ORDER BY upper(lname) ASC
</CFQUERY>
thanks!
_____________________________
Daniel Kessler
Department of Public and Community Health
University of Maryland
Suite 2387 Valley Drive
College Park, MD 20742-2611
Phone: 301-405-2545
http://hhp.umd.edu
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220652
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
