[python-sybase] Having a problem with rowcount

[Nicholas V. <nic...@pl...>]

So I am using FreeTDS with Python and Sybase.py.

I am do a connection, cursor, execute a query and can fetch the results =
of the query.
All that works.

But when I go to change the code to check the rowcount for the status of =
the query,=20
it is always -1.   Should it not be set to the number of rows in the =
query, which for my
query is like 50.

Here is the code (basically):

conn =3D Sybase.connect( cfg['dsn'], cfg['user'], cfg['pass'] )
cursor =3D conn.cursor()
cursor.execute ("SELECT id, queuetype FROM Components")

print "XXX: rowcount:", cursor.rowcount

while (1):
        row =3D cursor.fetchone()
        if row =3D=3D None: break
        print row

connect.close()

Thanx
Nicholas