pysqlite2 fetching from select different than pysqlite?

[schwehr at gmail.com]

Hi All,

I have some old pysqlite 1.x code that uses a pattern like this:

cu.execute('SELECT weight FROM weights WHERE samplename="foo")
row = cu.fetchone()
weight=row['weight']

It seems like lookups by name are no longer supported in pysqlite2.  Is
that true?  And if not, and I want to do a SELECT * FROM table and go
through name by name, how can I do this?

Hopefully this is not a FAQ somewhere that I've overlooked!

Thanks!
-kurt