Hello, I failed to use zope-pygresqlda as described in the mail before. According to a hint I fiedled around with capitalisation of the database field MenuItem but nothing helped. I wonder if I should give psycopg a try. Formerly I had serious problems when trying to install Popy so I see new light on the horizon now. Seems to be a little bit hard for a beginner like me to get PostgreSQL connection working. Unfortunately I missed the URL where I can obtain psycopg in the thread named "best postgreSQL adapter?". Can somebody give me a link? Kind regards Andreas. For the record of my previous problem: 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