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

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


Jon Jensen wrote:
> On Tue, 6 Aug 2002, Joachim Leidinger wrote:
> 
> 
>>[query list=1 sql="select DISTINCT Untergruppenummer, Gruppe, 
>>Untergruppe, Gruppenummer from products WHERE Sonderposten NOT LIKE 'S' 
>>ORDER BY Gruppe, Untergruppe;"]
> 
> [snip]
> 
>>Why is [sql-param Untergruppenummer] etc. empty?
> 
> 
> I believe field names need to be in all lower case or all upper case, but 
> I could be wrong.

BINGO!
Field names need to be in all lower case. That works! :-)

Thank you very much!
Herzlichen Dank!

Joachim


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