From: Warren Young
Date: October 23 2005 4:51am
Subject: Re: Nested queries
List-Archive: http://lists.mysql.com/plusplus/5043
Message-Id: <435B16B6.1010100@etr-usa.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

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.