I'd like to pass in a string and a list to a ZSQL method.
ids: [1, 2, 3, 4, 5]
I'd like to create a ZSQL method that does an update on multiple rows.
Arguments: user, ids
SET Owner = <dtml-sqlvar user type="string">
WHERE Id IN <dtml-sqltest ids type=int multiple>
I'd like the SQL to look like this:
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?
Zope-DB mailing list