MySQLdb "Attribute Error in .fetchall"
Miles Thompson
milesthompson at sprint.ca
Mon Sep 25 15:36:14 EDT 2000
This is solved. I downloaded again, rebuilt and copied the code .... it
works.
Miles Thompson
Miles Thompson wrote:
> I'm working up a little script to parse a cursor. After establishing the
> database connection, I issue the following ...
> pcursor.execute("select * from subscriber where lpasswd_mailed = 0;")
>
> resultset = pcursor.fetchall()
>
> The fetchall() call returns the following error:
> File "usr/lib/python1.5/site-packages/MySQLdb.py", line 231, in fetchall
>
> return.self.result.fetch_all_rows()
> AttributeError: fetch_all_rows
>
> Is this a problem in MySQLdb.py. or is it choking on a datatype? The
> table structure is quite simple:
> create table subscriber (
> sn_numb char(5) not null,
> email char(50),
> sn_cpasswd char(8),
> lpasswd_mailed tinyint not null, # default is 0-false
> dtupdated timestamp, # automatically updated when record changed
> primary key (sn_numb) );
>
> This is Python 1.5, MySQLdb2.2 and MySQL 3.22.32
>
> Regards - Miles Thompson
More information about the Python-list
mailing list