ODBC Select

[Larry]

I am trying to connect to my MySQL database using python and ODBC.

Here is what I am doing.

 >>> import dbi,odbc
 >>> conn=odbc.odbc("dsn=facs")
 >>> cursor=conn.cursor()
 >>> cursor.execute("select * from data")
0
 >>>

Notice I get the "0" after the select statement.
Problem is, there are 20 records in the database.  In fact I can do this

 >>> cursor.execute("insert into data (facility) values ('AAA')")
1
 >>>

and then I can do this

 >>> cursor.execute("delete from data where id > 20")
1
 >>>

but when I do

 >>> cursor.execute("select * from data")
0
 >>>

Anyone seen this and can maybe tell me why this is occuring.  I have 
full privileges as I can log on and query with the DSN from other programs.

Thanks,
Larry