Re: [Tutor] tutorial for dbapi 2.0 how to use data

[Magnus Lycka]

John Fabiani wrote:
> mycur=con.cursor()
> mycur.execute("select * from sosord")
> mydata=mycur.fetchmany(10)
> 
> The above works and returns data.  But know I need to understand how to 
> view the data.  Maybe there is a way to convert the returned list into a 
> dictionary.  A dictionary would allow me to get information by key (the 
> field name).  Anyway, is there some paper or tutorial I can read on how 
> to view the return data?

There are some links at:
http://www.thinkware.se/cgi-bin/thinki.cgi/ObjectRelationalMappersForPython

For instance, you can use db_row:
http://opensource.theopalgroup.com/files/db_row.html

dtuple, SQLDict and dbObj do similar things.

-- 
Magnus Lycka, Thinkware AB
Alvans vag 99, SE-907 50 UMEA, SWEDEN
phone: int+46 70 582 80 65, fax: int+46 70 612 80 65
http://www.thinkware.se/  mailto:magnus at thinkware.se