[Zope] ZSQL Methods and multiple SQL statements

[Jon Dyte]

Hi

is it the intention that ZSQLMethods could contain more than
one SQL statement?

eg (ridiculous example I know)

insert into foo values('bar'); delete from foo


obviously in the case of query, you only get the last result set.


The reason I ask, is that this currently doesnt work with
ZMySQLDA 2.08 / MySQLdb 0.9.1

This seems to be because in the mysql client the call to
mysql_real_query c function is only expected to take one
SQL statement. Of course the code above works correctly
in the mysql interactive prompt.


If the ZSQLMethod is meant to take multiple statements
then I'd better look at fixing it.

What do the other DA products do?


Thanks

Jon