[Zope] PostgreSQL Problem

Andreas Tille tillea@rki.de
Tue, 13 Mar 2001 17:01:10 +0100 (CET)


Hello,

I'm using Zope 2.2.2 and zope-pygresqlda 0.3rjr2.  I have created the
following ZSQL method (here displayed in the "Test"-View):

 Z SQL Method at /Control_Panel/Products/Ifsg/GetMainMenu=20
                                                                          =
=20
 Idmenushow  Idwebseite  Menuitem
 54          25          Description
 57          110         Components
 61          71          Objectives
 52          20          Links
 51          57          About us


SQL used:

SELECT i.IdMenuShow, i.IdWebSeite, i.MenuItem FROM Menu m=20
     INNER JOIN MenuItem i ON i.IdMenu =3D m.IdMenu=20
     WHERE  m.IdMenu =3D 52
     ORDER BY i.Sort ;


I try to use the output of this Query in the following DTML-document:

 DTML Document at /Control_Panel/Products/Ifsg/Databasetest
=20

  <dtml-var standard_html_header>


  <dtml-in GetMainMenu>
    <dtml-var Menuitem><br>
  </dtml-in>
  <dtml-var standard_html_footer>


If I try to "View" Databasetest I get:

  Zope Error

  Zope has encountered an error while publishing this resource.=20

  Error Type: KeyError
  Error Value: Menuitem

Could anybody enlighten me, what=B4s the problem here?

Kind regards

      Andreas.