[Zope] Howto debug (Re: PostgreSQL Problem)

[Andreas Tille]

Hello,

I really wonder how to do debugging in Zope.  I tried several things
regarding to the available documentation and because I've got no answer
over this list I think there is no problem in the code I posted (see
below).

Are there any methods to track down the problem?
I know that many people use PostgreSQL with Zope but I wonder how they
got their very first example working :-(.

Kind regards

        Andreas.

On Tue, 13 Mar 2001, Andreas Tille wrote:

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