10 Feb
2004
10 Feb
'04
8:07 p.m.
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