[Zope] MySQL Temporary Tables & Z SQL Queries

Michael T. Babcock mike at triplepc.com
Tue Feb 10 15:07:22 EST 2004


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.

Any suggestions?
-- 
Michael T. Babcock



More information about the Zope mailing list