[ic] Range Searching part 2

Mike Heins interchange-users@lists.akopia.com
Sun Jun 17 23:14:01 2001


Quoting Victor Nolton (ven@pragakhan.com):
> Since my initial post I've tried literally hundreds of combinations 
> to get a simple range search to work.  I can get it to return results 
> but they are not in the range. I'm getting results for items that 
> don't even have a value for the field that has the range.
> 
> I've tried the examples from the old simple catalog, and samples from 
> the docs and from the website.
> 
> I just need to do a simple range search for a column and i'm using a 
> normal flatfile DB.
> 
>    <form action=[process-search] method=post>
>     <input type=hidden name=fi value=products>
>     <input type=hidden name=ra value=yes>
>     <input type=hidden name=rl value=bedrooms>
>     <input type=hidden name=rm value=4>
>     <input type=hidden name=rx value=7>
>     <input type=submit value=search>
>     </form>

Try this:

    <form action=[process-search] method=post>
     <input type=hidden name=fi value=products>
     <input type=hidden name=ra value=yes>
     <input type=hidden name=co value=yes>

     <input type=hidden name=sf value=bedrooms>
     <input type=hidden name=se value=4>
     <input type=hidden name=op value=">=">
     <input type=hidden name=nu value="1">

     <input type=hidden name=sf value=bedrooms>
     <input type=hidden name=se value=7>
     <input type=hidden name=op value="<=">
     <input type=hidden name=nu value="1">
     <input type=submit value=search>
     </form>

Range look should still work, but it has been a while since it
was tested.

-- 
Red Hat, Inc., 131 Willow Lane, Floor 2, Oxford, OH  45056
phone +1.513.523.7621 fax 7501 <mheins@redhat.com>

People who want to share their religious views with you
almost never want you to share yours with them. -- Dave Barry