Michael Schwartz wrote at 2005-5-15 16:30 -0400: >I am trying to find sample code for performing transactions in ZSQL with >mysql 4.1. I'd like to do something like this: > >1 - Insert record A into USER table >2 - Get auto_increment id for record A >3 - Insert record B into WIDGET table with auto_increment id from >previous step > >But if step 3 fails, I want to undo step 1.
Provided you use transactional tables (i.e. you use MySQL in a way that it support transactions), then you only need to abort the Zope transaction (which happens automatically when an exception reached ZPublisher). -- Dieter _______________________________________________ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db