En Tue, 20 Oct 2009 23:41:10 -0300, David Sfiligoi <sfili...@gmail.com>
escribió:
whatever prior date I put in the table's last task date colum somehow
they are not seen by the SELECT query
sqlcur.execute("SELECT `url`d` from `url_snapshot` WHERE `url` = %s and
`lastsnapshotdate` < %s",(url,currentdate))
that query returns old data.
Just like if the query is cached....yet the data actually changed in the
database.
If you want to keep the cursor open, you must commit the (implicit)
current transaction, even if it only contains selects (a rollback would
work too).
Alternatively, lower the transaction isolation level below "repeatable
reads". Note that in other scenarios, ensuring that the same query returns
the same results is a Good Thing.
--
Gabriel Genellina
--
http://mail.python.org/mailman/listinfo/python-list
