[ic] Range Searching part 2

Victor Nolton interchange-users@lists.akopia.com
Sun Jun 17 23:24: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.

That did the trick, im just going to end up compounding this with 
various other searches/ranges.

Is it more efficent to try to get a range to work or use the above 
with selection dropdowns? using IC 4.6.5

Thank you for the snippet.

Ven