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