[Zope] Searchiong for Psycopg (Was: PostgreSQL Problem)

Paolo Comitini pcm@mixadlive.com
Wed, 14 Mar 2001 12:43:26 +0100


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