[ic] Range Searching part 2

Victor Nolton interchange-users@lists.akopia.com
Thu Jul 5 17:38:00 2001


>Quoting Victor Nolton (ven@pragakhan.com):
>>  Quoting me:
>>  >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
>>
>
>This is definitely more efficient, especially if you combine it
>with something like
>
>	sf=property_type
>	se=Single family
>	nu=0
>	op=eq
>
>When the searchtype is db, and it is SQL, it builds the list
>with a fast select (providing property_type is indexed).


I'm having difficulties compounding the searches. the problem seems 
to be when they don't select another dropdown. is it better to make
value="" or Value="0" . search works perfect if just one is used 
(meaning the other code is removed).

Here is a small snippet
     <form action=[process-search] method=post>
      <input type=hidden name=fi value=products>
      <input type=hidden name=ra value=yes>
      <input type=hidden name=or value=no>
      <input type=hidden name=ml value=15>
      <input type=hidden name=tf value=Price>
      <input type=hidden name=to value=nr>
      <input type=hidden name=co value=yes>

  <br> bedrooms    <input type=hidden name=sf value=Bedrooms>
      <select name=se>
      <option value="0"> -
      <option value="1"> 1
      <option value="2"> 2
      <option value="3"> 3
      <option value="4"> 4
      <option value="5"> 5
      <option value="6"> 6
      </select>
      <input type=hidden name=op value=">=">
      <input type=hidden name=nu value="1">

      <input type=hidden name=sf value=Bedrooms>
      <select name=se>
      <option value="0"> -
      <option value="1"> 1
      <option value="2"> 2
      <option value="3"> 3
      <option value="4"> 4
      <option value="5"> 5
      <option value="6"> 6
      </select>
      <input type=hidden name=op value="<=">
      <input type=hidden name=nu value="1">

<br>Bathrooms

      <input type=hidden name=sf value=Bathrooms>
      <select name=se>
      <option value="0"> -
      <option value="1"> 1
      <option value="2"> 2
      <option value="3"> 3
      <option value="4"> 4
      <option value="5"> 5
      <option value="6"> 6
      </select>
      <input type=hidden name=op value=">=">
      <input type=hidden name=nu value="1">

      <input type=hidden name=sf value=Bathrooms>
      <select name=se>
      <option value="0"> -
      <option value="1"> 1
      <option value="2"> 2
      <option value="3"> 3
      <option value="4"> 4
      <option value="5"> 5
      <option value="6"> 6
      </select>
      <input type=hidden name=op value="<=">
      <input type=hidden name=nu value="1">


      <input type=submit value=search>
      </form>