What do you mean by the <!--#sql-delimiter-->? ---------- From: Rob Page Sent: Wednesday, July 21, 1999 11:12 PM To: HCSCCS Cc: zope Subject: RE: [Zope] Bulk insert in Zope's ZPyGres MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.1960.3) Content-Type: text/plain

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