[ic] sql search equivalent

[interchange-users@interchange.redhat.com (Scott Andreas)]

Good Day List!

I'm using [search-region] method and I have an SQL select statement that I'm
trying to convert to the IC search statement

my sql statement is...

sql="SELECT country, mv_shipmode, completed, show_qty
			FROM catalogs
			WHERE (country <> 'US' AND mv_shipmode = '1' AND completed <> '1') OR
(show_qty >= '2' AND show_qty <= '45' AND mv_shipmode = '1' AND completed <>
'1')


so far I have...

[search-region search="
		fi=catalogs
		st=db
		co=yes
		sf=country
		op=ne
		se=US
		sf=mv_shipmode
		op=eq
		se=1
		sf=completed
		op=ne
		se=1
		or=1
		sf=show_qty
		op=ge
		se=2
		sf=show_qty
		op=le
		se=45
		sf=mv_shipmode
		op=eq
		se=1
		sf=completed
		op=ne
		se=1

rf=code,salesrep,district,institut,fname,lname,address1,address2,city,state,
zip,country,weight"]

But doesn't give me the desired results

Also, I've tried using sq="SQL statement" as an alternative but I wasn't
able to get it to work either.

Thanks in Adv.

J. Scott Andreas :)
IS/Programmer/WebDevelopement
Learning Services, Inc.
e-mail: sandreas@learningservicesinc.com
phone: 1-800-877-9378 ext. 146
fax: (541) 744-2056
       ---    __o
     ---   _-\<,_
      --- (_)/ (_)