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