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

[Gilles Lenfant]

Many thanks Hans and Paul.

"<dtml-var sql_delimiter>" works perfectly.
Just it was not on my Zope book (the French one).
I needed multiple "insert" in the database.
Of course, multiple select has no sense ;-)

--Gilles

----- Original Message ----- 
From: "Paul Zwarts" <paz@oratrix.com>
To: "'Gilles Lenfant'" <glenfant@bigfoot.com>
Cc: <H.de.Wit@SFK.NL>; <zope@zope.org>
Sent: Tuesday, November 27, 2001 4:17 PM
Subject: RE: [Zope] Multiple queries in a ZSQL method (MySQLda)


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