from ZSQL Methods User's Guide, last row on pag. 22: "Note that no more than one SQL select statement may be used in a single SQL Database Method." Diny van Gool wrote:
Hi,
I want to execute multiple SQL statements in one SQL-Method. In the mailinglist archives i found the answer but when i try it i get an error:
Error, exceptions.ValueError: multiple selects are not allowed
I used a simple Z SQL Method query (Zope 2.2.2) just to try:
select * from GENEESM_DIER
<dtml-var sql_delimiter>
select * from TOED_WIJZE
What am i doing wrong?
Diny
DIVA, Faculty of Veterinary Medicine Utrecht University, The Netherlands http://www.vet.uu.nl
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )