[Zope] How can run multiple query in an Z sql method

[Marco Bizzarri]

On 3/9/07, Jary Busato <jbusato at libero.it> wrote:
> Marco Bizzarri ha scritto:
> > On 3/9/07, Jary Busato <jbusato at libero.it> wrote:
> >> If I understood you're telling me that begin and commit statements are
> >> "redundant".
> >
> > Yes, exactly: they are issued by Zope at the boundaries of a transaction.
> >
> >> Sometimes conflicts are not correctly managed by ZTM (no rollbacks in
> >> db)
> >
> > Are you using a non-transactional database (like old MySQL version)?
> >
> >
> sql server with ZODBC
>

Sorry, I don't have direct experience with it. However, IIRC, ZODBC is
quite old and could have some problems. I would suggest you to invest
a few Euros in mxODBC: I've never tried it but Egenix has a good
record of producing good products.

Regards
Marco


-- 
Marco Bizzarri
http://iliveinpisa.blogspot.com/