Witango-Talk: Problems w/ Temporary tables in MYSQL

[Bill Conlon]

I have  a query that works fine in mysql from the command line.  I've 
verified that there is no issue with ODBC by running the same query 
thru phpMyAdmin (which runs on my server thru the same ODBC as Witango).

I've narrowed it down to Witango DirectDBMS not liking Temporary 
Tables.  Here's the simplest query to demonstrate this:

CREATE TEMPORARY TABLE  tmp_table (id INT) TYPE=HEAP;
DROP TABLE tmp_table;
Anyone have any clues on using Temporary tables.
FYI, the temporary tables are a work-around for some issues (lack of 
sub-selects, some quirks with JOIN) in MySQL 3.23.  It looks like I'll 
have to do multiple queries and then combine the results in Witango.

thx
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf