[ic] searching for this or that and the_other
Doug Alcorn
doug@lathi.net
04 May 2001 00:51:56 -0400
The way MySQL interprets it, I can do
select code from products where addl_category like something or
addl_category = 'something else' and category = 'another';
this is the same as ({(a =~ /something/) or (b = 'something else)) and
(c = 'another')). i can't seem to get this to work in IC. here's my
sameple little test page:
[set dka_model]NOK6100[/set]
[seti addlcat_profile]
sf=addl_category
op=rm
se=[scratch dka_model]
os=yes
sf=addl_category
se=universal
[/seti]
[bounce href="[area href=|scan| arg=|
fi=products
st=db
sp=results2
mp=addlcat_profile
os=no
sf=category
se=Cases
|
]"]
The above works fine as long as i leave out the
os=yes/sf=addl_category/se=universal. When I put it in, the search
says that there is nothing that matches. mathematically, shouldn't
the return set always be larger with an ORed clause?
--
(__) Doug Alcorn <doug@lathi.net> http://www.lathi.net chat:lathinet@yahoo|aol
oo / PGP 02B3 1E26 BCF2 9AAF 93F1 61D7 450C B264 3E63 D543
|_/ If you're a capitalist and you have the best goods and they're
free, you don't have to proselytize, you just have to wait.