[Zope-DB] [ANN] SQLAlchemyDA 0.3.0 released - a generic database adapter for Zope 2

2007-06-16 Thread Andreas Jung
I am pleased to announce the first public release of SQLAlchemyDA V 0.3.0 Download: - http://opensource.zopyx.com/software/sqlalchemyda/releases/0.3.0 What is SQLAlchemyDA? - SQLAlchemyDA is generic database adapter for ZSQL methods. Since it

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

2007-06-16 Thread Ken Winter
Jaroslav ~ I'm pretty sure that 'delete_this' is a list (of integers), because the lines p = context.REQUEST.get('delete_this') s = ', '.join([str(x) for x in p]) process it correctly into the string 's'. In other words, I think it is the same as if p had been assigned a list in this way:

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

2007-06-16 Thread Andreas Jung
First, Jaroslav is right. One time you're passing a string and next your passing a list. Make your choice how the API should looks like. 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 :-) -aj --On 16.

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

2007-06-16 Thread Ken Winter
Andreas ~ Here's the whole traceback (and all the other details from my Plone error log): Time 2007-06-16 15:33 User Name admin (admin) Request URL http://localhost/DAgroups/portal_factory/People/people.2007-06-16.3625931808 /people_edit Exception Type KeyError Exception Value

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 in

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

2007-06-16 Thread Charlie Clark
Am 17.06.2007, 00:14 Uhr, schrieb Ken Winter [EMAIL PROTECTED]: dtml-comment title: Method to delete one Person by id connection_id: dhatabase arguments: person_id /dtml-comment delete from person where person_id = dtml-var person_id When I tried to delete a couple of People