[Zope-DB] newbie DTML: multiple WHERE

[Charlie Clark]

On 2005-05-22 at 19:43:31 [+0200], Michael Schwartz <mike at ziacom.us> wrote:
> UPDATE myTable
> SET Owner = foo
> Where Id IN (1,2,3,4,5)
> 
> I wish there were more examples up online for ZSQL, especially for those
> of us who are using ZPT, and DTML is somewhat foreign. For example, could
> I use a dtml-sqlgroup or dtml-in to solve this?

Personally I would recommend you use as little DTML as possible in your 
ZSQL as it makes debugging it a lot easier.

The following should work

UPDATE myTABLE
SET Owner = 'foo'
WHERE id IN <dtml-var ids>

you can user dtml-var to pass in a Python list that will not be quoted.

Charlie
-- 
Charlie Clark
eGenix.com

Professional Python Services directly from the Source
 >>> Python/Zope Consulting and Support ...        http://www.egenix.com/
 >>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::