[Zope] multiple selects are not allowed

[Jose Soares]

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 )