[Zope] Bulk insert in Zope's ZPyGres

[Rob Page]

> Thanks. But how do use insert statements thru Z SQL Mtehod 
> submitting it   
> again? We will need to submit the web page a lot of times to 
> get the   
> variables across, wouldn't we? How do we address this problem ?

<SNIP>

if the checkboxes are called:  list_of_things:list

then in the SQL Method:

<!--#in list_of_things-->
   INSERT INTO data_table 
   (field1, field2, field3)
   VALUES 
   (
      <!--#sqlvar sequence-item fmt=string-->, 
      <!--#sqlvar some_other_thing_from_the_form1 fmt=string-->, 
      <!--#sqlvar some_other_thing_from_the_form2 fmt=string-->
   )
   <!--#sql-delimiter-->

<!--#/in-->

--Rob