[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