> > 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
> >
; " TYPE=HEAP
MAX_ROWS=1 " << subselect;
try
{
query.parse();
query.execute();
}
- Original Message -
From: "Phil Bitis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 09, 2003 12:41 PM
Subj
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 v4.0.1
