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

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/