[Zope] PostgreSQL Problem

13 Mar 2001

      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 

 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 
     INNER JOIN MenuItem i ON i.IdMenu = m.IdMenu 
     WHERE  m.IdMenu = 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

  <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. 

  Error Type: KeyError
  Error Value: Menuitem

Could anybody enlighten me, what´s the problem here?

Kind regards

      Andreas.

[Zope] PostgreSQL Problem

Andreas Tille