Hi Don,
It might be worth your time to look into using Lucene for this, and
using the ERIndexing framework a search returns EOs.
The query syntax is very flexible and a range search like you are
describing could just be the the start:
http://lucene.apache.org/java/2_3_2/queryparsersyntax.html
I think your range search would ultimately include something like this:
gauge:[.347 TO .357]
:)
Asa
On Oct 2, 2009, at 5:27 PM, Don Lindsay wrote:
Hello;
I know I have asked many questions this week. :) This is the first
time I have attempted a search of this magnitude in WebObjects. I
have users who are able to specify a parameter. For instance the
gauge of a steel pipe (.357), I want them to be able to enter a
default variance (.010) to apply to any query they run and be able
to return the results ( would end up as between .347 and .357.)
I can use QueryMin and QueryMax and java code, but that seems not
very WOish (requires too much work and WO typically doesnt require
alot of work).
The query would be run against thousands to millions of records and
return matching items. Presenting the user with items that fall
within their variance when they login to the application (and
display them 10 at a time using a WORepetition).
I know how to do this in SQL, but would prefer to use the WebObjects
methodology to accomplish this goal. Any ideas or suggestions?
Thanks
Don
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/a.talk
%40zenn.net
This email sent to [email protected]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
