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