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.
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 sql_delimiter> Curtis.
Thats it, great thanks. (A search through the ZopeBook and Docs produces no matches) -- Andy McKay. ----- Original Message ----- From: "Curtis Maloney" <curtis@cardgate.net> To: "Andy McKay" <andym@ActiveState.com>; <zope@zope.org> Sent: Wednesday, January 17, 2001 4:41 PM Subject: Re: [Zope] SQL delimiter?
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 sql_delimiter>
Curtis.
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, any number of SQL statments may be in a ZSQL Method, although at most one may be a SELECT. If you know your databases convention, you can use the normal separator, i.e. PostgreSQL supports ';' as the separator. Just do it. This may cause portability problems. <dtml-var sql_delimiter> is supposed to be portable.
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
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>. I just needed that yesterday, and I found it on p 28 of my printed (from PDF) copy of the Z SQL Methods User's Guide, in the "Query Templates" section (huh?). -- Fred Yankowski fred@OntoSys.com tel: +1.630.879.1312 Principal Consultant www.OntoSys.com fax: +1.630.879.1370 OntoSys, Inc 38W242 Deerpath Rd, Batavia, IL 60510, USA
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 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.
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
participants (5)
-
Andy McKay -
Curtis Maloney -
Fred Yankowski -
Jose Soares -
jpenny＠universal-fasteners.com