[ic] search spec problem...

[Kevin Walsh]

mail <lists at gmnet.net> wrote:
> I'm still having trouble with a search spec and I can't seem to solve
> it. This entire search-region is inside a loop which is also inside
> another loop.  each loop has its own prefix.
> 
> Here is my search spec:
> 
>   [search-region
>   prefix=resources
>   list_prefix=resources_list
>   search=|
>   fi=resources
>   st=db
>   co=1
>   sf=categorycode
>   se=[scratch categorycode]
>   op=eq
>   nu=0
>   sf=topiccode
>   se=[scratch topiccode]
>   op=eq
>   nu=0
>   sf=loscore
>   se=[scratch score]
>   op=<=
>   nu=1
>   sf=hiscore
>   se=[scratch score]
>   op=>=
>   nu=1
>   sf=inactive
>   se=1
>   op=ne
>   nu=0
>   ml=none
>   |]
> 
> here is a simplified view of my resources table:
> code categorycode topiccode loscore hiscore inactive
> 1  1  1   0  .2  0
> 2  1  1  .3  .5  0
> 3  1  1  .6  .8  0
> 4  1  1  .9   1  0 
> 5  2  1   0  .2  0
> 6  2  1  .3  .5  0
> 7  2  1  .6  .8  0
> 8  2  1  .9   1  0
> 
> If I set my scratch variables as follows:
> categorycode = 1
> topiccode = 1
> score = .0000001
> I get what you would expect (row 1 only)
> 
> If I set my scratch variables as follows:
> categorycode = 1
> topiccode = 1
> score = .3333
> I get what you would expect (row 2 only)
> 
> However, If I set my scratch variables this way:
> categorycode = 1
> topiccode = 1
> score = 0
> I get rows 1, 2, 3, and 4.
> 
> I have tried setting the loscore and hiscore fields in the database as
> various types including double, float, decimal, and even text.
> Does anybody have any ideas? 
> 
I find that it's much easier to just use SQL for anything other than
just a simple search.  Perhaps you should consider using the [query]
tag instead.  I'm sure you'll find it much easier to work with and
to get going.

It doesn't sound too efficient to have loops nested in the way you've
described.  You may be able to create a single SQL query that does the
whole job in one loop.

I can't see anything too obvious in your search spec that I can point
at for you.  Check that [scratch score] is indeed set to the value you
expect.  Perhaps show the value on your page to debug it.   Your
"inactive" spec should probably have op=!= and  nu=1, but that's
irrelevant to your reported problem.  I really would just use SQL.

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