> > 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=10000 " << subselect;
> >
> > try
> > {
> > query.parse();
> > query.execute();
> > }
> >
>
> This is simple to solve.
>
> As recommended in MySQL++ manual, use stream only for queries returning
result set. For the queries like above use exec() method.
Point taken, changed it to just use exec() and the same problem occurs. It
was working previously with the code above though (mysql 3), and it works
fine entered at the mysql console.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
