[Zope] Call SQLMethods/SQL Statements directly with python

Casey Duncan casey@zope.com
Thu, 04 Apr 2002 13:38:09 -0700


If you still want to use a zope database adapter, you can do it like this:

     db = self.database_adapter_id()
     i,rows = db.query('...SQL Statement(s)...')

     for row in rows:
         process the rows


hth,
-Casey


Philipp Giere wrote:
> Hello!
> Somebody out there who can give me a hint how to call SQL directly 
> from python and not with SQLMethods
> 
> Thank you!
> 
> Philipp
> 
> 
> _______________________________________________
> 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 )
> 
>