[ic] searching with numbers

[Kevin Walsh]

mail <lists at gmnet.net> wrote:
> Hi, I have an interesting problem when trying to search for data within
> a number range.
> 
> The table that I am searching has a "loscore" column, and a "hiscore"
> column and defines the "range" of that row. the total range would be
> between -1 and 1. 
> 
> I have a search area that looks for data within that range based on a
> "score".  the "score" is set in a scratch variable, the score can be
> anywhere from -1 to 1.  
> 
> I have the following in a search area:
> 
>   sf=loscore
>   se=[scratch score]
>   op=<=
>   nu=1
>   sf=hiscore
>   se=[scratch score]
>   op=>=
>   nu=1
> 
> Is this the right way to do it? I must be doing something wrong, because
> when the "score" is 0, all rows are returned. What is the best way to do
> this type of search?
> 
You probably only need to add "co=1" to your search spec:

    http://www.interchange.rtfm.info/icdocs/Interchange_search_engine.html#Coordinated_and_joined_searches

-- 
   _/   _/  _/_/_/_/  _/    _/  _/_/_/  _/    _/
  _/_/_/   _/_/      _/    _/    _/    _/_/  _/   K e v i n   W a l s h
 _/ _/    _/          _/ _/     _/    _/  _/_/    kevin at cursor.biz
_/   _/  _/_/_/_/      _/    _/_/_/  _/    _/