Programming Forums - View Single Post

big_k105 · May 9th, 2007, 12:17 PM

I think the problem could be that after you insert or delete you have to commit the query by running connection.commit().

http://mysql-python.sourceforge.net/...ection-objects

I could be wrong as I have never used MySQLdb but it might be worth a shot

edit: check this out
http://mysql-python.sourceforge.net/...-won-t-go-away
it says that MySQLdb disabled autocommits in version 1.2.0 so you will have to run the connection.commit() before you close the connection or all changes will not be committed to the db.

May 9th, 2007, 12:17 PM	#2
big_k105 PFO Founder Join Date: Mar 2004 Location: Fargo, ND Posts: 1,630 Rep Power: 10	I think the problem could be that after you insert or delete you have to commit the query by running connection.commit(). http://mysql-python.sourceforge.net/...ection-objects I could be wrong as I have never used MySQLdb but it might be worth a shot edit: check this out http://mysql-python.sourceforge.net/...-won-t-go-away it says that MySQLdb disabled autocommits in version 1.2.0 so you will have to run the connection.commit() before you close the connection or all changes will not be committed to the db. __________________ BIG K aka Kyle Programming Forums Kyle K Online Please do not PM or email me programming questions. Post them in the forums instead.