RE: [Zope-DB] Two actions in one ZSQL method = one transaction?

2007-06-14 Thread Ken Winter
-Original Message- From: Andreas Jung [mailto:[EMAIL PROTECTED] Sent: Thursday, June 14, 2007 12:54 AM To: Ken Winter; 'Zope-DB List' Subject: Re: [Zope-DB] Two actions in one ZSQL method = one transaction? ... Does a ZSQL method initiate a database transaction, so that no other

RE: [Zope-DB] Two actions in one ZSQL method = one transaction?

2007-06-14 Thread Andreas Jung
--On 14. Juni 2007 10:41:46 -0400 Ken Winter [EMAIL PROTECTED] wrote: -Original Message- From: Andreas Jung [mailto:[EMAIL PROTECTED] Sent: Thursday, June 14, 2007 12:54 AM To: Ken Winter; 'Zope-DB List' Subject: Re: [Zope-DB] Two actions in one ZSQL method = one transaction

RE: [Zope-DB] Two actions in one ZSQL method = one transaction?

2007-06-14 Thread Ken Winter
Great! Thanks again. -Original Message- From: Andreas Jung [mailto:[EMAIL PROTECTED] Sent: Thursday, June 14, 2007 10:48 AM To: Ken Winter; 'Andreas Jung'; 'Zope-DB List' Subject: RE: [Zope-DB] Two actions in one ZSQL method = one transaction? --On 14. Juni 2007 10:41:46 -0400

[Zope-DB] Two actions in one ZSQL method = one transaction?

2007-06-13 Thread Ken Winter
I have a question (stated in three different ways) about the following ZSQL method: 1. Will it *always* return the person_id of the person that it just inserted? 2. Will it do this even if another user inserted another person just in between the two SQL actions in this ZSQL method? 3. In

Re: [Zope-DB] Two actions in one ZSQL method = one transaction?

2007-06-13 Thread Andreas Jung
--On 13. Juni 2007 21:11:08 -0400 Ken Winter [EMAIL PROTECTED] wrote: I have a question (stated in three different ways) about the following ZSQL method: 1. Will it *always* return the person_id of the person that it just inserted? You have to answer this question your self. It depends on