Re: [Zope-DB] [Zope] ZSQL Methods and transaction control

2007-01-10 Thread Charlie Clark
Am 10.01.2007, 17:00 Uhr, schrieb robert rottermann <[EMAIL PROTECTED]>: thanks for your suggestion. i am using mxODBC for 2 cusomers and I was under the impression, that it is used (as the name suggests) to connect to a odbc database. would using it mean that I had to access MySQL trough odbc.

Re: [Zope-DB] [Zope] ZSQL Methods and transaction control

2007-01-10 Thread robert rottermann
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Charlie Clark schrieb: > Am 10.01.2007, 13:16 Uhr, schrieb robert rottermann <[EMAIL PROTECTED]>: > >> thanks charlie, >> so that means, that the _commit and _abort methods are only for zope's >> transaction controll. > > Yes, and with good reason. >

Re: [Zope-DB] [Zope] ZSQL Methods and transaction control

2007-01-10 Thread Maciej Wisniowski
>> thanks charlie, >> so that means, that the _commit and _abort methods are only for zope's >> transaction controll. > Yes, and with good reason. But I think that if you know what your'e doing you may use them althought it may be tricky. It is better to try external method like Charlie suggested

Re: [Zope-DB] [Zope] ZSQL Methods and transaction control

2007-01-10 Thread Charlie Clark
Am 10.01.2007, 13:16 Uhr, schrieb robert rottermann <[EMAIL PROTECTED]>: thanks charlie, so that means, that the _commit and _abort methods are only for zope's transaction controll. Yes, and with good reason. do you have a suggestion how then to start/commit a transaction from within a ZSQL

Re: [Zope-DB] [Zope] ZSQL Methods and transaction control

2007-01-10 Thread robert rottermann
Charlie Clark wrote: > Am 10.01.2007, 13:00 Uhr, schrieb robert rottermann <[EMAIL PROTECTED]>: > >> I understand that there is a way to handle transaction control in the >> ZMySQL methods. However I find no documentation at all on how to use it. > > This is incorrect. ZSQL methods are called withi

Re: [Zope-DB] [Zope] ZSQL Methods and transaction control

2007-01-10 Thread Charlie Clark
Am 10.01.2007, 13:00 Uhr, schrieb robert rottermann <[EMAIL PROTECTED]>: I understand that there is a way to handle transaction control in the ZMySQL methods. However I find no documentation at all on how to use it. This is incorrect. ZSQL methods are called within Zope transactions so you n

[Zope-DB] [Zope] ZSQL Methods and transaction control

2007-01-10 Thread robert rottermann
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi there, I am implementing a tool to handle userdata that is stored in a MySQL db. The underlaying logic of the stored procedures used to maintain the db content dictate that I have to control the transactions myself. I understand that there is a wa