[ic] search for xyz from fields uvw with field abc !~ S

[Joachim Leidinger]

Joachim Leidinger wrote:
> > Ed,
> >
> > you are right! It does not work. But
> >
> > [seti scanparams][area href="scan/co=yes/sf=Artikelnummer/se=[scratch
> > searchstring]/su=1/op=rm/sf=Sonderposten/se=S/op=rn.html"][/seti]
> >
> > works with IC 4.6.1!
> 
> Ooops. I mean IC 4.6.5! The above code works. But I want to search for
> [scratch searchstring] over several fields with no items, which has "S"
> in the field "Sonderposten". I've tried
> 
> [seti scanparams][area
> href="scan/co=yes/sf=Artikelnummer,Kurzbeschreibun/se=[scratch
> searchstring]/su=1/op=rm/sf=Sonderposten/se=S/op=rn.html"][/seti]
> 
> and
> 
>  [page  search.0="
>                        sf=Artikelnummer,Kurzbeschreibung
>                        se=3311
>                        su=1
>                        op=rm
>                  "
>         search.1="
>                        sf=Sonderposten
>                        se=S
>                        op=!~
>                  "
> ] TEST scan [/page]
> 
> with no luck. The wrong item with "S" in the field "Sonderposten" is
> still displaying in my results page.
> If I've more than one fields in the first "sf=", it fails and is
> displaying the wrong items with "S" in the field "Sonderposten".

How can I do 

[query sql="select * from products where Artikelnummer LIKE 3311 AND
Sonderposten !='S'"
       type=list
       more=1
       ml=10]
[list]
[sql-code] [sql-param Kurzbeschreibung] <FONT COLOR="RED">[sql-param
Sonderposten]</FONT><BR>
[/list]
[/query]

with the scan or search params like

[area scan or search ????]

?
The query statement is exactly, what I want. List all items with the
partial string "3311" and not with "S" in field "Sonderposten".

[seti scanparams][area href="scan/co=yes/sf=Artikelnummer/se=[scratch
searchstring]/su=1/op=rm/sf=Sonderposten/se=S/op=rn.html"][/seti]

works,

[seti scanparams][area
href="scan/co=yes/sf=Artikelnummer,field1,field2,field3,etc./se=[scratch
searchstring]/su=1/op=rm/sf=Sonderposten/se=S/op=rn.html"][/seti]

does not works.

[seti scanparams][area href="scan/co=yes/sf=*/se=[scratch
searchstring]/su=1/op=rm/sf=Sonderposten/se=S/op=rn.html"][/seti]

does not works too.

Any ideas?

Thanks!

Joachim

-- 
Hans-Joachim Leidinger | Dipl.-Phys.Ing. Entwicklung eCommerce
[Hans-Joachim.leidinger@bpanet.de]
Black Point Arts Internet Solutions GmbH
http://www.bpanet.de