[Zope] Bulk insert in Zope's ZPyGres

[Paul Chung Chee Soong]

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