On Feb 10, 2004, at 3:07 PM, Michael T. Babcock wrote:
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.
A Python script should be able to handle this: res = context.myQuery() context.closeTempTable("temp") return res Just make a separate ZSQL method that closes the table, and call it from your script. ___/ / __/ / ____/ Ed Leafe http://leafe.com/ http://opentech.leafe.com