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.

 

Do I need to back out manually?

 

Thanks in advance!

 

Mike Schwartz

 

 

_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Reply via email to