List:MySQL++« Previous MessageNext Message »
From:Chris Frey Date:October 24 2005 10:50am
Subject:Re: Nested queries
View as plain text  
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:
http://tangentsoft.net/mysql++/doc/userman/html/overview.html#id2810307

- Chris

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.
> 
> //Mattias
> 
> 
> 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
> >
> >
Thread
Nested queriesMattias Fliesberg21 Oct
  • Re: Nested queriesChris Frey21 Oct
    • MySQL DevelopmentFabricio Mota22 Oct
  • Re: Nested queriesWarren Young23 Oct
    • Re: Nested queriesMattias Fliesberg24 Oct
      • Re: Nested queriesChris Frey24 Oct
Re: Nested queriesJonatan Taminau21 Oct