I think that your problem is in the fact that you have fed them all in
one long string (and may have autocommit on.)
If they were separate ZSQL methods, they would, in my experience,
I recommend separating them into separate methods, with one insert
[EMAIL PROTECTED] wrote on 04/25/2006 10:38:30 AM:
> For some reason I thought ZSQL method calls were atomic, but they appear
> Using an eGenix mxODBC Database Connection at
> /Database/PoPy_database_connection to a SQL Server 2000 back end, I have
> created a Python script to write SQL commands and feed them in one large
> How can I detect failure and maintain atomicity?
> Michael Maslak, Jr.
Zope maillist - Zope@zope.org
** No cross posts or HTML encoding! **
(Related lists -