Re: [Zope] SQL delimiter?
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 - [EMAIL PROTECTED] 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 ) ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] SQL delimiter?
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 - [EMAIL PROTECTED] 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 )
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. ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] SQL delimiter?
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 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. ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] 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? 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 [EMAIL PROTECTED] tel: +1.630.879.1312 Principal Consultant www.OntoSys.com fax: +1.630.879.1370 OntoSys, Inc 38W242 Deerpath Rd, Batavia, IL 60510, USA ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] 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, 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 - [EMAIL PROTECTED] 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 ) ___ Zope maillist - [EMAIL PROTECTED] 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 )
