Multiple SQL statements/queries in one SQL method?
10 May
2002
10 May
'02
11:10 p.m.
Can this be done? I need a "set role ..." before executing any select. Regards, Dietmar
11 May
11 May
3:48 a.m.
New subject: [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/
8731
Age (days ago)
8732
Last active (days ago)
1 comments
2 participants
participants (2)
-
Dietmar Schwertberger -
Stuart Bishop