[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