The pyscopg homepage is here: http://initd.org http://initd.org/Software/psycopg Regards Paolo Comitini pcm@initd.org On Wednesday 14 March 2001 11:45, Andreas Tille wrote:
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
_______________________________________________ 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 )
-- Paolo Comitini paolo.comitini@mixadlive.com Mixad Live s.r.l. http://www.mixadlive.com tel +39-0125-669020, fax +39-0125-668984 via della Cartiera 2 10010 - Parella (TO) Italy