Saludos, Sorry dude, but this is an RTFM issue. ZSQL methods dont use the same syntax as normal sql. Separation is done by: <dtml-var sql_delimiter> instead of ';'. However, everything else is normal sql as you know it. Anyone know a db that allows multiple selects in a single statement without creating a temporary table? Cheers, Paul Zwarts -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org] On Behalf Of Julián Muñoz Domínguez Sent: Wednesday, October 31, 2001 10:44 AM To: zope@zope.org Subject: [Zope] How work transactions in Zope ?? How could I do a transaction with ZODBC DA ?? I am accesing to a Jet Database (.mdb file) If I put several sql commands in a same zsql method (separated with ;), the driver complais. Or is it implicit ? (ie I shoud call several Zsql method from a Python script) -- __o _ \<_ (_)/(_) Saludos de Julián EA4ACL -.-