-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi there,
I am implementing a tool to handle userdata that is stored in a MySQL db. The underlaying logic of the stored procedures used to maintain the db content dictate that I have to control the transactions myself. I understand that there is a way to handle transaction control in the ZMySQL methods. However I find no documentation at all on how to use it. Without using ZMySQL methods I would be using the following piece of code: db = mysql.connect(host="localhost" ...) cursor = db.cursor() query = "CALL insertUser('%s', '$xxx$', @id, @error);select @id, \ @error" % 'JohnTheUser') cursor.execute(query) # get the next resultset, it has the result of the select cursor.nextset() result = cursor.fetchall()[0] error = int(result[1]) if error: print "error %s when trying to add user %s" % (ERRRORS[error],\ 'JohnTheUser') db.rollback() continue #we are in a loop actually .. db.commit() How can I mimic that using ZSQL Methods thanks for any pointers Robert -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org iD8DBQFFpNVkGaryJ0T9kUYRAhWfAJ9MTOqEu2PXnUQlVJRfof8hj5zXcgCeJoCt Dij5NsSXbjc6FWYE5i9nMTE= =6Qql -----END PGP SIGNATURE----- _______________________________________________ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db