sqlite query not working

John Salerno johnjsal at NOSPAMgmail.com
Wed Nov 8 10:53:21 EST 2006


Dennis Lee Bieber wrote:

> 	The other thing to consider is that, if you were testing using a
> single cursor, and single session, the database would have shown you
> uncommitted changes. It wouldn't have been until you closed the
> cursor/connection without a commit that the DBMS would have tossed them
> -- a select would still retrieve your uncommited changes during that
> transaction.

Good point, and I wouldn't be surprised if I had done that too! Working 
with databases in Python (as opposed to direct command line queries) is 
fairly new to me, so who knows what crazy things I tried to do. :)



More information about the Python-list mailing list