Re: [Zope] SQL delimiter?

2001-01-18 Thread Jose Soares
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

Re: [Zope] SQL delimiter?

2001-01-17 Thread Curtis Maloney
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

Re: [Zope] SQL delimiter?

2001-01-17 Thread Andy McKay
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

Re: [Zope] SQL delimiter?

2001-01-17 Thread Fred Yankowski
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.

Re: [Zope] SQL delimiter?

2001-01-17 Thread jpenny
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,