[Zope] Multiple queries in a ZSQL method (MySQLda)

[Paul Zwarts]

Greetings,

As Hans mentions, you use the <dtml-var sql_delimiter>
(&dtml-sql_delimiter;) construction for multiple statements in a single
ZSQL method. But concerning multiple queries (selects), AFAIK, this is
limited in SQL to 1 per statement... Unless you use more complicated SQL
like select into or using a nested select inside brackets.

Cheers,
Paul Zwarts


-----Original Message-----
From: zope-admin@zope.org [mailto:zope-admin@zope.org] On Behalf Of
H.de.Wit@SFK.NL
Sent: Tuesday, November 27, 2001 3:35 PM
To: zope@zope.org
Subject: Re: [Zope] Multiple queries in a ZSQL method (MySQLda)



>Is there a workaround to have those 2 SQL queries in one ZSQL method ?
I
 use this thing:
<dtml-var sql_delimiter>

I see no other purpose for it than abstracting from ';', (but i don't
know
if this works in your configuration)


Met vriendelijke groeten,

Hans de Wit
Stichting Farmaceutische Kengetallen
Postbus 30460
2500 GL  DEN HAAG
Tel. 070-3737448
Fax 070-3737445




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