[Zope-DB] Re: Using multiple in zsql where clause?

Jeff Kowalczyk jtk@yahoo.com
Tue, 19 Nov 2002 15:10:02 -0500


> container.sqlupdate(ShipmentID=['12345', '54321'], ShipperChargeAsBilled=54.32)

Correction, the script call does in fact work with

where
<dtml-sqltest ShipmentID type="nb" op="eq" multiple>

So, using multiple select form elements or checkbox collections should now be practical.

Still, Is there an expression syntax to use multiple with the zsql method's test page, so
I can see what SQL is being generated? I just wanted to know for a future occasion when
the existence of multiple values trigger something more complicated. Thanks.