[ic] OR search on subcategories (revised)
Thu, 7 Dec 2000 07:15:37 -0500
Quoting John Nealy (email@example.com):
> Sorry about the bad reply,folks, it was a rough day. Also forgot to say I am using PostgreSQL
> 6.5 for the
> database on RH 6.0.
> What I did try so far was the following:
> Using the UI I put in
> Which returns the message "No match found for All Motorola".
> Next I replaced that code with sq=select * from products where subcategory =
> 'All' or subcategory like 'Motorola' and I got the same message. I am
> working on the assumption that in the UI I do not need the [loop] or [query]
> tags because they will be generated. Is this correct? Thanks so much for
> the help and patience.
You need two os=1 parameters --- they do cascade. The value applies to
the left-hand side of the term it is used for. I suppose I could shift
them one....it didn't occur to me. I can't really do it different now,
it would kill anyone who already is using it.
If you want to make absolutely sure:
sr=0 or 1
The mv_search_relate allows you to do complex groupings like:
sr=((0 and 1) or (2 and ! 3) ) or 4
One of these days I will put in the code to map SQL statements to the
sr= search relation.
I think I will put in an ag= parameter to automatically generate groups
Akopia, Inc., 131 Willow Lane, Floor 2, Oxford, OH 45056
phone +1.513.523.7621 fax 7501 <firstname.lastname@example.org>
Fast, reliable, cheap. Pick two and we'll talk. -- unknown