[DB-SIG] pyodbc: help interpreting help

M.-A. Lemburg mal at egenix.com
Thu Oct 7 11:13:07 CEST 2010

Goldsmith, David wrote:
> Hi!  Probably 'cause I'm new to DBs, I'm having trouble understanding
> pyodbc's help.  For example, what kind of Python object is a "results
> set"?  In particular, the syntax portion of the docstring for the tables
> method of a cursor object states that it returns self, but the text
> portion of the docstring says it "creates a results set of tables
> defined in the data source."  It goes on to say that "each row fetched
> has the following columns: ...2) table_name: The table name..."  It is
> simply a Python list of these that I want, but the API for actually
> returning such is far from clear: how does one access the collection of
> "fetched rows" (what kind of Python object is the collection and what is
> its name in the local dictionary) and how does one "slice out" one or
> more columns from it?  Please help.  Thanks!

Not sure whether that's an option, but you could try our mxODBC
which uses standard tuples, lists, etc.:


Here's the documentation:


or for online reading (but not as nicely formatted):


Marc-Andre Lemburg

Professional Python Services directly from the Source  (#1, Oct 07 2010)
>>> Python/Zope Consulting and Support ...        http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/

::: Try our new mxODBC.Connect Python Database Interface for free ! ::::

   eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
    D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
           Registered at Amtsgericht Duesseldorf: HRB 46611

More information about the DB-SIG mailing list