Re: EO Raw Row Query
Re: EO Raw Row Query
- Subject: Re: EO Raw Row Query
- From: Art Isbell <email@hidden>
- Date: Tue, 17 Dec 2002 15:44:56 -1000
On Tuesday, December 17, 2002, at 12:34 PM, Jonathan Fleming wrote:
I have a singe search box that I would like to be able to find items
from different entities (which I am achieving ok through my EO
bindings), but what I am failing to achieve is being able to put
several queries in the box for it to find eg. "music" + "japan".
Although these are properties in one or more tables/enterties that
can be found in seperate queries, i can not mix the two like you
would in a top search engine, I can only put in "music" and the do
my search which results in a list of items with that category,
or "japan" which will result with item of that country.
How do I do this - join the two or three or four? You get my drift.
The short answer is that databases don't, in general, support text
searching in the manner of search engines. Search engines create large
indexes of searchable text so that hits can be found quickly.
Databases can create indexes of the entire value of a column, not of
individual words in that value. Using standard SQL via a JDBC
interface would result in a very slow search if the database were very
large. Some databases are implementing text search capabilities
including indexing, but you'd probably have to access this
functionality through database-specific commands instead of the
standard SQL that's generated by EOF.
About the best you could do to mimic search engine behavior would be
to parse the search criteria yourself creating an EOQualifier for every
search string and "and'ing" these qualifiers whenever a '+' is
encountered. Each EOQualifier would have to be something like
"attributeName like '*music*'" and "attributeName like '*Japan*'" in
which wildcards surround each search string. If you want
case-insensitive searching (really slow!), you'd need to use the
"caseinsensitiveLike" operator.
Art
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.