Re: [ic] Range Searching part 2

[Mike Heins <mheins@redhat.com>]

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).

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

If you think nobody cares if you're alive, try missing a couple of
car payments.  -- Earl Wilson