Re: [Zope-DB] Managing Connections with SQL Methods

2005-10-27 Thread Chris Withers
Why don't you just use ZSQL Methods?! Chris Seth Gottlieb wrote: The problem seemed to be that Zope.app() was returning a new root object instance every time a new DAO (data access object) was initialized. After 3, boom. The work around is to pass the context of the calling object with

[Zope-DB] Managing Connections with SQL Methods

2005-10-25 Thread Seth Gottlieb
Hi, I have a Python class that my Zope application uses to talk to a relational database (MySQL for now). I am using a Z SQL Connection (ZMySQLDA) object to handle DB connectivity. When I initialize, I get a handle of the connection object like this: import Zope setattr(self,