[DB-SIG] mxODBC query results as dictionaries

M.-A. Lemburg mal@lemburg.com
Thu, 18 Oct 2001 10:03:19 +0200


> Joseph Wilhelm wrote:
> 
> I scanned through the archives of this mailing list, and saw a bit of
> a discussion about this subject... but I couldn't find a final
> definitive answer on it. What is the recommended way, if any, to get
> rows from a an mxODBC cursor as a dictionary, in the form [
> "column_name" : "column_date" ] ?

Here are some links:

	http://www.lyra.org/greg/python/ (look for dtuple.py)
	http://rtfm.n3.net/software/psql/	
	http://dustman/net/andy/python/SQLDict/

Even though mxODBC provides the needed information for dictionary
mappings (column names and values), there is the problem of
columns which have database generated names, e.g. for DB functions.

-- 
Marc-Andre Lemburg
CEO eGenix.com Software GmbH
______________________________________________________________________
Consulting & Company:                           http://www.egenix.com/
Python Software:                        http://www.lemburg.com/python/