Postgresql defaults all column names to lower case so Menuitem is actually menuitem try this Dan
<dtml-in GetMainMenu> <dtml-var Menuitem><br> <---------- change to <dtml-var menuitem><br> </dtml-in> <dtml-var standard_html_footer>
Andreas Tille wrote:
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.
_______________________________________________ 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 )