Re: Nested queries - Mattias Fliesberg - com.mysql.lists.plusplus

7 messages in com.mysql.lists.plusplusRe: Nested queries

From	Sent On	Attachments
Mattias Fliesberg	21 Oct 2005 03:34
Jonatan Taminau	21 Oct 2005 06:53
Chris Frey	21 Oct 2005 07:12
Fabricio Mota	22 Oct 2005 04:55
Warren Young	22 Oct 2005 21:50
Mattias Fliesberg	24 Oct 2005 02:14
Chris Frey	24 Oct 2005 03:50

Subject:	Re: Nested queries
From:	Mattias Fliesberg (matt...@gmail.com)
Date:	10/24/2005 02:14:37 AM
List:	com.mysql.lists.plusplus

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 <mysq...@etr-usa.com> 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.