[ic] Can't get OR complex searches to run - need SQL how to

[Mike Heins]

Quoting Kevin Old (kold@carolina.rr.com):
> Hello all,
> 
> I have a store selling movies.  I have to "genre codes" of movies that
> I'd like to appear under one Category.  I can't get the following
> complex search to work for me:
> 
> [area	href=scan
> 	search=|
> 		
> 		fi=products
> 		st=db
> 		os=yes
> 		co=1
> 		
> 		sf=category
> 		se=FAM
> 		op=rm
> 		nu=0
> 		
> 		sf=category
> 		se=CLL
> 		op=rm
> 		nu=0
> 		
> 		ml=50
> 	|
> ]
> 
> I basically want to display all items in the products table with the
> category of "FAM" OR "CLL".  All I get back is no matches, when I'm sure
> there's data there.

You need to add another "os=yes".

Or you can simply do:

	fi=products
	ac=0
	sf=category
	se=FAM|CLL

It would be faster and less load on your database if you exported
it to the text file and put st=text.

-- 
Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.513.523.7621      <mike@perusion.com>

I don't buy from direct telephone or email marketers.  This makes it
hard for me to find a phone company. ;>