[Zope] Zope/PostgreSQL/PoPy

[Antonio JesÚS Carrasco GarcÍA]

Russell Hires wrote:



> I'm in the same boat. When I was having trouble connecting to the
PostgreSQL
> db, I got an interesting response from Thierry Michel, the author of of
the
> PoPy adapter: look at the permissions on the database. Sure enough, I
didn't
> have permission to make a local connection.
>
> I told you all of that so I could tell you this: I think this might be the
> same error: something may be wrong at the db level, and not with zope or
the
> adapter. Of course, I have no idea what it could be, and I've checked a
> number of PostgreSQL docs to find out what could be the problem with
"string"
> but nothing yet. I tried the "nb" type as well, and no go. I haven't done
too
> much with the numeric types yet...maybe I'll test those to make sure they
all
> work. But float does!
>

So..., what can we do?. I have been looking for information in some
PostGreSQL docs, Python docs, Zope docs (ZSQL Method), but nothing. I´m sure
it works for float and int types, but with string or nb, it doesn´t work.
the error line in PoPy_DA.py is:
    find=string.find
So, is it a "casting" problem of python, or PostGreSQL?.
Are we going to use another db (MySQL, Gadfly (;-D), ...) to solve our
problem?
Who can say us something about how to solve the problem?.

This a serious thread of Zope Mail. "To use, or not to use PostGreSQL, this
is our question"


> Russell
> On Wednesday 22 August 2001 15:47, you wrote:
> > Hello all,
> >
> >   I have successfully installed the PoPyDA product in Zope and am able
to
> > query existing PostgreSQL databses but am getting the following error
when
> > I try to INSERT a new record into the database:
> >
> > Error, exceptions.NameError: global name 'string' is not defined
> >
> > <snip/>
> >
> >   File /usr/local/zope/lib/python/DocumentTemplate/DT_String.py, line
544,
> > in __call__ (Object: <string>)
> >   File /usr/local/zope/lib/python/Shared/DC/ZRDB/sqlvar.py, line 206, in
> > render (Object: job_num)
> >   File /usr/local/zope/lib/python/Products/zpopyda/PoPy_DA.py, line 103,
in
> > sql_quote__ (Object: RoleManager)
> > NameError: (see above)
> >
> >
> >   I'm using the <dtml-sqlvar name type="string"> tag to insert the
> > variables, which works fine when I use Gadfly.
> >
> >   If anyone has any suggestions (or a FM I can R), I be most
appreciative.
> >
> > Thanks,
> > Matt Hand
> > matt@bitflip.com
> >
> >
> > _______________________________________________
> > 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 )
>
> _______________________________________________
> 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 )
>