You need to insert the following line between two SQL statements.
dtml-var sql_delimiter
Remember you can't use it with more than one SELECT.
sql_delimiter is usefull only to separate more than one
INSERT, UPDATE, DELETE.
Jos
Andy McKay wrote:
Ive looked through the docs and Im sure I saw
On Thursday 18 January 2001 11:36, Andy McKay wrote:
Ive looked through the docs and Im sure I saw once (but cant see it now),
some sort of delimiter between SQL statements allowing me to put multiple
SQL statements in one SQLMethod. Was I imagining that?
--
Andy McKay.
dtml-var
Thats it, great thanks.
(A search through the ZopeBook and Docs produces no matches)
--
Andy McKay.
- Original Message -
From: "Curtis Maloney" [EMAIL PROTECTED]
To: "Andy McKay" [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, January 17, 2001 4:41 PM
Sub
On Wed, Jan 17, 2001 at 04:36:29PM -0800, Andy McKay wrote:
Ive looked through the docs and Im sure I saw once (but cant see it now),
some sort of delimiter between SQL statements allowing me to put multiple
SQL statements in one SQLMethod. Was I imagining that?
It's dtml-var sql_delimiter.
On Wed, Jan 17, 2001 at 04:36:29PM -0800, Andy McKay wrote:
Ive looked through the docs and Im sure I saw once (but cant see it now),
some sort of delimiter between SQL statements allowing me to put multiple
SQL statements in one SQLMethod. Was I imagining that?
--
Andy McKay.
No indeed,