From: Warren Young
Date: June 30 2005 2:15am
Subject: Re: Stored Procedures & Multiple Result Sets
List-Archive: http://lists.mysql.com/plusplus/4576
Message-Id: <42C355C6.5010705@etr-usa.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Jalon, Arnon wrote:
> was able to figure this out by hacking connection.h to make the MYSQL
> instance variable public, and then using it to iterate through the
> result sets using mysql_next_result and mysql_free_result c api calls in
> my code after processing the result set that I wanted, which seemed to
> cause the error to disappear.  I was wondering if there is any way to
> deal with multiple result sets in mysql++, or if there is any planned
> support for it down the road?

Sounds like you're more than halfway there already.  Why don't you clean 
that up, and provide it as a diff against v2.0 brewing in Subversion?

	http://gna.org/projects/mysqlpp/

It's probably going to be most useful for your new functions to go 
either in ResUse/Result or in Query.  I'd lean towards putting in in 
Query, since it's natural to ask it for result sets, rather than 
treating the one result set Query returns as a virtual set of results. 
Connection's MYSQL member will not need to be promoted to the public 
section in this situation.

But don't let me talk you into too many design details.  You're the man 
on the ground... you know what the semantics should look like, not I. 
Just do it cleanly, that's the main thing.