You could use the query.store() call instead of query.use()... this returns
a Result object instead of a ResUse, storing the results in memory all
at once, just like PHP's mysql_query().
See the docs:
On Mon, Oct 24, 2005 at 11:14:59AM +0200, Mattias Fliesberg wrote:
> Oh, of course it does. But how is it solved in PHP?
> I know you can do it there...
> I've tried the seperate connection solution but it didn't
> work, guess I'll try it again.
> On 10/23/05, Warren Young <mysqlpp@stripped> wrote:
> > Mattias Fliesberg wrote:
> > >
> > > I'm trying to execute a query, within another queries loop.
> > The MySQL C API that underlies MySQL++ imposes restrictions on that.
> > RTFM. You must consume all rows from a SELECT before you can issue
> > another query on the same connection.
> > To get around this, you can use separate Connection objects, and get a
> > Query object from each one.
> > --
> > MySQL++ Mailing List
> > For list archives: http://lists.mysql.com/plusplus
> > To unsubscribe: http://lists.mysql.com/plusplus?unsub=1