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!
-------------------------------------- David Goldsmith Washington State Department of Ecology Environmental Assessment Program Modeling and Information Support Unit 300 Desmond Drive | P.O. Box 47600 Lacey, WA 98503 | Olympia, WA 98504-7600 Tel: (360) 407-6194 Fax: (360) 407-6884 Email: david.goldsm...@ecy.wa.gov <mailto:david.goldsm...@ecy.wa.gov> Station: C2D-59 Web: http://www.ecy.wa.gov/programs/eap/ <http://www.ecy.wa.gov/programs/eap/>
_______________________________________________ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig
