How does one execute several SQL statements in one Z SQL Method object? The Zope Help screens assure me that this is possible, but neither this or the Zope Book actually say how. (I do not want to return any results, since these are insert queries anyway.) David
On Mon, 2 Sep 2002 16:36:16 +0100 (BST) DA Loeffler <David.Loeffler@bristol.ac.uk> wrote:
How does one execute several SQL statements in one Z SQL Method object? The Zope Help screens assure me that this is possible, but neither this or the Zope Book actually say how. (I do not want to return any results, since these are insert queries anyway.)
<!--#var sql-delimiter--> See <http://mail.python.org/pipermail/zope/1999-August/092280.html> I guess it still works in new money .... See also <http://www.zope.org/Documentation/Books/ZopeBook/current/AppendixA.stx> for a note of this omission. Paul -- The Library, Tyndall Avenue, Univ. of Bristol, Bristol, BS8 1TJ, UK E-mail: paul.browning@bristol.ac.uk URL: http://www.bris.ac.uk/
On Mon, 2002-09-02 at 11:36, DA Loeffler wrote:
How does one execute several SQL statements in one Z SQL Method object?
Separate them with <dtml-var sql_delimiter> -- Andy Dustman PGP: 0x930B8AB6 @ .net http://dustman.net/andy "Cogito, ergo sum." -- Rene Descartes "I yam what I yam and that's all what I yam." -- Popeye
DA Loeffler writes:
How does one execute several SQL statements in one Z SQL Method object? The Zope Help screens assure me that this is possible, but neither this or the Zope Book actually say how. (I do not want to return any results, since these are insert queries anyway.) One uses "<dtml-var sql_delimiter>" to separate the SQL statements.
Dieter
participants (4)
-
Andy Dustman -
DA Loeffler -
Dieter Maurer -
Paul Browning