[ic] Search problem ...
Stefan Hornburg
racke at linuxia.de
Fri May 20 02:28:28 EDT 2005
Marco Mescoli wrote:
>Example:
>In the table products i would search all records that have:
>
>(substring "one" inside field1 or inside field2 or inside field3) and
>(field4="two") and (field5="three");
>
>I can make this query with SQL but this way it is not applicable inside a
>[search-region ] like my needs.
>
>Have you suggestions ?
>
You can use search groups. The following example searches for CDROM and
(scope = 1 or scope = 3) if SCOPE equals 1.
__NAME__ cdrom::star::new
st=db
ml=20
co=yes
tf=name
lf=category3
sf=class
se=CDROM
op=eq
[if variable SCOPE eq 1]
sg=0
os=0
sg=1
os=1
sf=scope
se=1
sg=1
os=1
sf=scope
se=3
[/if]
__END__
Bye
Racke
More information about the interchange-users
mailing list