[Zope] ZSQL question

Antonio Carrasco antoniojezu@hotmail.com
Thu, 30 Aug 2001 01:15:06 +0200


Hi all. Hi Kerekes.
----- Original Message ----- 
From: "Kerekes Lajos" <lkerekes@xperts.hu>
To: <zope@zope.org>
Sent: Thursday, August 30, 2001 4:10 PM
Subject: [Zope] ZSQL question


> 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

Mmmm. I see a SQL question. Try

"SELECT SUM(AMOUNT) AS SUMMA, NAME FROM LOG GROUP BY NAME"


> 
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )
>