> P.S. I know that rather than is an
> unorthodox and apparently undocumented construct to use within a ZSQL
> definition. But I need it because malformats the string.
>
What do you mean by 'malformats the string'?
Have you tried dtml-sqltest clause? It may be used to do
'where colname in
> I tried to invoke the "query" method of my adapter (which is named
> "dhatabase") with this code:
>
> "
> p = context.REQUEST.get('delete_this')
> if p:
> s = ', '.join([str(x) for x in p])
> t = "delete from person where person_id in (%s);" % s
> context.dhatabase.query(query_string
Ken Winter wrote at 2007-6-16 16:03 -0400:
> ...
>Exception Type
>KeyError
>Exception Value
>'id_list'
>
>Traceback (innermost last):
> ...
>* Module Products.CMFCore.FSPythonScript, line 164, in _exec
>* Module None, line 4, in people_delete_control
> /DAgroups/portal_factory/
> -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 s in ZSQL methods?
>
...
> FWIW you
> might want to call the query or execute methods directly on the DA
> connection