Gilles Lavaux wrote:

Hello all,

(NB:Axel.Missbach has asked the same thing some days ago)

Sorry if it's a well_documented_somewhere/stupid question, that's my problem:

I want to update a database, several tables, in one http call. I use DTML+Zsql methods, several of them during this update. How can I put theses actions inside one transaction?

I use ZPopyDA+ postgresql

I would appreciate an answer to this. I think it's a 'basic' problem on a www+DB system, and that it's very easily solved if you use a perl-DBI cgi. But with Zope I was unable to find a hint in the documentation/mailing list. Is it possible to do all the work inside an external method using directly the PoPy library and using the commit/rollback??

Zope does the transactions automatically - i.e. it either commits or aborts all work done in one http request. That is true for both ZODB and most DA-s, including PoPyDA. ---------- Hannu