[Zope] multiple INSERT in one sql method

Daniel M. Drucker dmd@3e.org
Fri, 4 Jun 1999 18:54:10 -0400 (EDT)


> Is it possible to do more than one INSERT in a single SQL method?

Apparently not, but I also tried the following and it returned to me this:

 ok you added foo
 ok you added bar
 ok you added baz

But the database was NOT modified.


thing.html:
<FORM METHOD=POST ACTION="inserts.html">
<SELECT NAME="asdf" MULTIPLE SIZE=4>
<option selected value="foo">foo
<option selected value="bar">bar
<option selected value="baz">baz
</SELECT>
<input type=submit></FORM>


inserts.html:
<!--#in asdf-->
<!--#call inserts(_.['sequence-item'])-->
ok you added <!--#var sequence-item--><br>
<!--#/in-->


inserts: (arguments: thingie)
INSERT INTO sodas VALUES (<!--#sqlvar thingie type=nb-->,'blah');