[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