Re: [ic] searching with numbers

[mail <suppressed>]

On Wed, 2007-04-18 at 19:05 +0100, Kevin Walsh wrote:
> mail <suppressed> 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
> 

Hi Kevin, sorry i didn't post the whole thing, here it is. I do have
that in there. I am also narrowing it down even further than that. I am
inside another loop where I setting a "topiccode" and a "categorycode"

  [search-region
  prefix=resources
  list_prefix=resources_list
  search=|
  fi=resources
  st=db
  co=1
  sf=categorycode
  se=[scratch categorycode]
  op=eq
  sf=topiccode
  se=[scratch topiccode]
  op=eq
  sf=loscore
  se=[scratch score]
  op=<=
  nu=1
  sf=hiscore
  se=[scratch score]
  op=>=
  nu=1
  sf=inactive
  se=1
  op=ne
  ml=none
  |]

If my [scratch score] is 0, it grabs all the rows in "resources" table
that match topiccode and categorycode. even if the loscore is .5 for
that row...  If the score is .1 or something, then it seems to only grab
the row that is in "range". Is there something else that I am missing?

Thanks again
Rick


_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users