[Zope] Multiple SQL statements/queries in one SQL method?

[Stuart Bishop]

On Saturday, May 11, 2002, at 09:10  AM, Dietmar Schwertberger wrote:

> Can this be done?
>
> I need a "set role ..." before executing any select.

You can seperate multiple SQL statements in a single ZSQL method
using <dtml-var sql_delimiter>.

eg::

	SET ROLE BLAH

	<dtml-var sql_delimiter>

	SELECT * FROM FOO



--
Stuart Bishop <zen@shangri-la.dropbear.id.au>
http://shangri-la.dropbear.id.au/