[Zope] PostgreSQL Problem

Oleg Broytmann Oleg Broytmann <phd@mail2.phd.pp.ru>
Tue, 13 Mar 2001 19:50:04 +0300 (MSK)


On Tue, 13 Mar 2001, Andreas Tille wrote:
> 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

   But what is the Menuitem? There is no such thing in the result of your
SQL query.

Oleg.
----
     Oleg Broytmann     http://www.zope.org/Members/phd/     phd@phd.pp.ru
           Programmers don't die, they just GOSUB without RETURN.