[ic] [sql-param myfieldname] is not working

Joachim Leidinger interchange-users@icdevgroup.org
Tue Aug 6 12:20:01 2002


Hi List,

I've

[query list=1 sql="select DISTINCT Untergruppenummer, Gruppe, 
Untergruppe, Gruppenummer from products WHERE Sonderposten NOT LIKE 'S' 
ORDER BY Gruppe, Untergruppe;"]

       [on_match]Matched<br>[/on_match]
       [no_match]Not Found<br>[/no_match]

[list]
[sql-code] -- [sql-pos 0] -- [sql-pos 1] -- [sql-pos 2] -- [sql-pos 3]<BR>
[sql-code] -- [sql-param Untergruppenummer] -- [sql-param Gruppe] -- 
[sql-param Untergruppe] -- [sql-param Gruppenummer]<BR>
[/list]
[/query]

and I get

Matched
1 -- 1 -- Audio/Video -- Antennenkabel -- 1
1 -- -- -- --
2 -- 2 -- Audio/Video -- Audio/Video Controller -- 1
2 -- -- -- --
3 -- 3 -- Audio/Video -- Cinch-Kabel -- 1
etc.

Why is [sql-param Untergruppenummer] etc. empty?

Thank you!

Joachim

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