[Zope] ZSQL question

[Kerekes Lajos]

Hi!

I have problem. Could you help me?
I have a ZSQLMethod, it contains
"SELECT SUM(AMOUNT), NAME FROM LOG GROUP BY NAME"
How can I reach the SUM value in dtml?

<dtml-in SelectMethod>
Name: <dtml-var NAME>, Summary of amount: <dtml-var ????>
<dtml-in>

I tried the :
"SELECT SUM(AMOUNT) SUMMA, NAME FROM LOG GROUP BY NAME"

<dtml-in SelectMethod>
Name: <dtml-var NAME>, Summary of amount: <dtml-var SUMMA>
<dtml-in>

but it gives
Error Type: KeyError
Error Value: SZUMMA

  Thank you:

    Lajos Kerekes