From: Warren Young
Date: December 19 2008 9:00am
Subject: Re: Can a connection be used to execute more than 1 query sequentially(not
 concurrently)
List-Archive: http://lists.mysql.com/plusplus/8289
Message-Id: <494B62B1.7040002@etr-usa.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

kartik mahajan wrote:
>                                     mysqlpp::Query q(conn->query("CALL
> getsubscriberdata('pri_1000000001@stripped',1)"));
> 
>                                     mysqlpp::StoreQueryResult res =
> q.store(); // This throws exception i.e out of sync

MySQL returns multiple results for a stored procedure call.  Until you 
consume all results, you can't make another query.

If you don't have any use for the other stuff MySQL returns, you can do 
something like this to throw it away:

             while (query.more_results()) {
                 res = query.store_next();
             }