[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] [sql-param myfieldname] is not working
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