Re: [Zope] MySQL Temporary Tables & Z SQL Queries

Michael T. Babcock wrote at 2004-2-10 15:07 -0500:

I have a query much like:

CREATE TEMPORARY TABLE temp SELECT * FROM FOO, FOO2 ... delimiter ... SELECT * FROM BAR LEFT JOIN temp

The problem is that because Zope doesn't close the connection, the temporary table is left around. If I drop the temporary table at the end of the query, I get no query results from Zope. If I don't, it complains on subsequent queries that the temp table exists already.

Are you using the "<dtml-var sql-delimiter>"? If you do, you should be able to delete the temporary table after the final "<dtml-var sql-delimiter>". -- Dieter