Also, you could always import the specific module for your database, and create a db connection, then execute() and fetch() directly. Although, if you are putting this in an external method, it would be wiser to use your existing ZSQL methods ;] Knight knight@phunc.com On Fri, 6 Oct 2000, knight wrote:
How do I get a zope database connection from an enternal method?
You can access your db using your existing ZSQL Methods by calling them from the namespace passed in, specifically self.
Example:
def myextmethod(self): mfl_id = 3 results = self.sqlCountUsers(mfl_id=mfl_id) for result in results: print result[0], result[3]
Keep in mind that a list is returned, not a dictionary.
Knight knight@phunc.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 )