[Tutor] SQL headache with column

Danny Yoo dyoo at hkn.eecs.berkeley.edu
Tue Jul 19 22:57:29 CEST 2005

On Tue, 19 Jul 2005, Bernard Lebel wrote:

> Ah yeah I to mention that I indeed tried fetchall(), but Python would
> raise an attribute error:

Hi Bernard,

The cursor itself holds some internal state that mutates when we call
cursor.execute().  So we use cursor.execute() often for it's side-effects.

Use fetchall on the cursor, not the resulting return value of the
execute()ion, and you should be ok.

Hope this helps!

More information about the Tutor mailing list