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

[Kevin Old]

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.

Now, I understand I can just hand code the sql for these links, but am
unsure of how to do it.  Just for clarification I'm wanting to make
these changes to the category_horizontal component.

I know it's something very simple I'm missing, but I'd appreciate any
help anyone can offer.  Also, any other menu bars anyone has created,
I'd love see the code.

Thanks,
Kevin
-- 
Kevin Old <kold@carolina.rr.com>