[Zope] argument type of list for ZSQL ?
Brian Withun
brianw@hilgraeve.com
Mon, 23 Oct 2000 11:24:17 -0400
Is it possible to create a ZSQL
Method which has a list-type as
an argument? ..something that
might support a call like this
(or similar):
<dtml-call expr="populate_department(dept_id=200,
dept_member_ids=[22,150,89])">
where inside the ZSQL Method I
might iterate over dept_members
<dtml-in dept_members>
INSERT DepartmentMembers ( department_id, employee_id )
VALUES ( <dtml-sqlvar dept_id type=int>, <dtml-var sequence-item> )
<dtml-var sql_delimiter>
</dtml-in>
If this can be written as shown
(or similar) what would be the
syntax used to populate the
'dept_members' field on the TEST
view of the ZSQL Method? Would
it just be:
dept_member_ids:
-----------------------
| [22,150,89] |
-----------------------
or
dept_member_ids:
-----------------------
| "[22,150,89]" |
-----------------------
or
... ?
------------
Brián Withun