[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');