Re: Can a connection be used to execute more than 1 query sequentially(not concurrently)

[Warren Young]

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();
             }