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

[interchange-users@interchange.redhat.com (Joachim Leidinger)]

Joachim Leidinger wrote:
> [seti scanparams][area href=scan
>        arg=|
>    co=yes
>    ml=20
>    sp=results
>    tf=RN
> 
> sf=Artikelnummer,Beschreibung,Beschreibung2,Beschreibung3,EKDM,Gruppe,Untergruppe,Kurzbeschreibung
>    se=[scratch searchstring]
>    op="rm"
>    sf=Sonderposten
>    se=S
>    op="rn"
>    |
> ]
> [/seti]
> 
> [tag op=header interpolate=1]
> Status: 302 moved
> Content-type: text/html
> Location: [scratch scanparams]
> [/tag]


[seti scanparams][area href=scan
           arg="
           st=db
           sq=select
Artikelnummer,Beschreibung,Beschreibung2,Beschreibung3,EKDM,Gruppe,Untergruppe,Kurzbeschreibung
from products where Artikelnummer LIKE [scratch searchstring] and
Sonderposten !='S'
"][/seti]

is exactly what I want and it works with IC 4.6.5!

Joachim

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