[Tutor] SQL headache with column

[Danny Yoo]

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!