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.