As a way of getting around the lack of subselect (I'm aware this is coming
soon) we're parsing sql queries, running subselects and storing their
results in a temporary table and replacing the subselect in the sql with the
temporary table name.
This has been working fine, but on upgrading to
;
try
{
query.parse();
query.execute();
}
- Original Message -
From: Phil Bitis [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 12:41 PM
Subject: Create Temporary Table problem
As a way of getting around the lack
Further to this, I should point out everything works fine in mysql-front
or at the mysql console.
The problem shows up when using mysql++, a BadQuery exception is thrown.
query.reset();
query CREATE TEMPORARY TABLE sTemporary TYPE=HEAP
MAX_ROWS=1