Never mind. The database user used by Witango did not have permission
to CREATE tables.
On Wednesday, December 29, 2004, at 09:14 PM, Bill Conlon wrote:
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
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
