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 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?

2001-01-17 Thread Andy McKay

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?

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 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?

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
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?

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.

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?

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, 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 )