[Zope-DB] A new event.log on every restart of Zope

2008-07-15 Thread Ken Winter
It would accelerate my Zope debugging cycle to have a new event.log file automatically started every time I restart Zope, with the old file preserved. It seems like a simple way to do this would be to modify the zope.conf eventlog entry, which currently reads like this. eventlog

[Zope-DB] Seeking help with Accessing Zope from PostgreSQL

2007-11-12 Thread Ken Winter
I'm trying to implement the scheme for Accessing Zope from PostgreSQL that is described in http://zope.org/Members/pupq/zope_in_pg. I'm trying to implement it in a Plone installation in a WinXP environment (Plone 2.5.2, Zope 2.9.6, Python 2.4.3, win32, PostgreSQL 8.1.10). I have changed the

RE: [Zope-DB] Using dtml-vars in ZSQL methods?

2007-06-18 Thread Ken Winter
-Original Message- From: Maciej Wisniowski [mailto:[EMAIL PROTECTED] Sent: Monday, June 18, 2007 1:34 AM To: Ken Winter Cc: 'Zope-DB List' Subject: Re: [Zope-DB] Using dtml-vars in ZSQL methods? I tried to invoke the query method of my adapter (which is named dhatabase

RE: [Zope-DB] Using dtml-vars in ZSQL methods?

2007-06-18 Thread Ken Winter
Thanks Charlie Jim ~ SQL injection is a new one on me, and I'm glad to learn about it now (painlessly) rather than later (painfully). ~ Ken -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, June 18, 2007 10:03 AM To: Ken Winter Cc: 'Zope-DB List

RE: [Zope-DB] Using dtml-vars in ZSQL methods?

2007-06-17 Thread Ken Winter
-Original Message- From: Charlie Clark [mailto:[EMAIL PROTECTED] Sent: Saturday, June 16, 2007 6:24 PM To: Ken Winter; 'Zope-DB List' Subject: Re: [Zope-DB] Using dtml-vars in ZSQL methods? ... FWIW you might want to call the query or execute methods directly on the DA connection

RE: [Zope-DB] Using dtml-vars in ZSQL methods?

2007-06-16 Thread Ken Winter
I have done. ~ Thanks ~ Ken -Original Message- From: Jaroslav Lukesh [mailto:[EMAIL PROTECTED] Sent: Saturday, June 16, 2007 1:41 AM To: Ken Winter; 'Zope-DB List' Subject: Re: [Zope-DB] Using dtml-vars in ZSQL methods? It is just because 'delete_this' is a string, not the list

RE: [Zope-DB] Using dtml-vars in ZSQL methods?

2007-06-16 Thread Ken Winter
PROTECTED] Sent: Saturday, June 16, 2007 3:27 PM To: Ken Winter; 'Zope-DB List' Subject: RE: [Zope-DB] Using dtml-vars in ZSQL methods? ... Second..it would be *really* helpful to see the full traceback instead of just *Keyerror*. It's somewhat boring to ask every time for it :-) --On 16. Juni

RE: [Zope-DB] Using dtml-vars in ZSQL methods?

2007-06-16 Thread Ken Winter
Charlie ~ I tried several experiments based on your suggestion. See results inserted below. ~ Thanks, Ken -Original Message- From: Charlie Clark [mailto:[EMAIL PROTECTED] Sent: Saturday, June 16, 2007 3:54 PM To: Ken Winter; 'Zope-DB List' Subject: Re: [Zope-DB] Using dtml-vars

[Zope-DB] Using dtml-vars in ZSQL methods?

2007-06-15 Thread Ken Winter
Here's the definition of a ZSQL method, people_delete_by_id.zsql: dtml-comment title: Method to delete People by ids given in a comma-separated list connection_id: my_database arguments: id_list /dtml-comment delete from person where person_id in (dtml-var id_list) Here's the

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 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] Seeking a suitable ZpsycopgDA

2007-05-01 Thread Ken Winter
Correction: What I'm looking for seems to be called ZpsycopgDA, not just psycopgDA. Anyway, I still haven't found it for the environment described below. Pls advise. ~ TIAA ~ Ken -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ken Winter Sent

[Zope-DB] Seeking a suitable psycopgDA

2007-04-30 Thread Ken Winter
I'm looking for the right version of psycopgDA for the following setup: Windows XP PostgreSQL 8.0 Zope 2.9.6-final Plone 2.5.2 (don't know if that matters) Python 2.4.3 Psycopg = win-psycopg24-pg8.0.zip downloaded from http://stickpeople.com/projects/python/win-psycopg/ MX Toolkit =