[Zope] Call SQLMethods/SQL Statements directly with python

[hans]

Casey Duncan wrote:

> 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

Serendipity!!
That's exactly the solution to one of the questions i'm pondering myself.
Thanks

> Philipp Giere wrote:
> > Hello!
> > Somebody out there who can give me a hint how to call SQL directly
> > from python and not with SQLMethods

-------------------------------------------------------------
Who's got only a hammer sees the world as a nail
hans augustin  (software developer)           hans@beehive.de
beehive elektronische medien GmbH       http://www.beehive.de
phone: +49 30 847-82 0                  fax: +49 30 847-82 299