[Zope] multiple selects are not allowed

Diny van Gool dvg@vet.uu.nl
Wed, 13 Dec 2000 08:54:26 +0100


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