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 )