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

[Stephen Prinster]

Larry wrote:

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

According to PEP 249, the return value for cursor.execute() is undefined
and there seems to be little documentation for the ODBC module, so my
guess (and I can't confirm it from home where I have no Windows) is that
0 indicates "success" and has nothing to do with the number of
records. Have you tried a "print cursor.fetchone()" to see if anything
is there?

[Larry]

> According to PEP 249, the return value for cursor.execute() is undefined

and there seems to be little documentation for the ODBC module, so my
guess (and I can't confirm it from home where I have no Windows) is that
0 indicates "success" and has nothing to do with the number of
records. Have you tried a "print cursor.fetchone()" to see if anything
is there?

Wow!
I feel silly!
Just as you said.
The records are there.
Thanks!

Larry