Re: Multiple result sets and the $sth-more_results method (Mark 3)

2005-05-04 Thread Steffen Goeldner
Tim Bunce wrote: On the occasion of the 1st anniversary - where did the time go? When a batch is first executed the statement handle appears exactly as if the batch only contained the first sub-statement. The only exception is that the $sth-{NUM_OF_PARAMS} attribute equals the total number

Re: Multiple result sets and the $sth-more_results method (Mark 3)

2005-05-04 Thread Tim
On Wed, May 04, 2005 at 01:17:00AM +0200, Steffen Goeldner wrote: Tim Bunce wrote: On the occasion of the 1st anniversary - where did the time go? [whoosh] When a batch is first executed the statement handle appears exactly as if the batch only contained the first sub-statement. The

Re: Multiple result sets and the $sth-more_results method (Mark 3)

2004-05-09 Thread Tim Bunce
On Sat, May 08, 2004 at 12:06:34PM -0700, Jonathan Leffler wrote: Tim Bunce wrote: On Tue, May 04, 2004 at 10:03:05AM +0100, Tim Bunce wrote: Here's a further update of what I'm thinking of with respect to $sth-more_results (many thanks for the valuable feedback). This is quite long

Re: Multiple result sets and the $sth-more_results method (Mark 3)

2004-05-08 Thread Jonathan Leffler
Tim Bunce wrote: On Tue, May 04, 2004 at 10:03:05AM +0100, Tim Bunce wrote: Here's a further update of what I'm thinking of with respect to $sth-more_results (many thanks for the valuable feedback). This is quite long because I've tried to consider all the issues. Anyone else got any comments?

Re: Multiple result sets and the $sth-more_results method (Mark 3)

2004-05-06 Thread Tim Bunce
On Tue, May 04, 2004 at 10:03:05AM +0100, Tim Bunce wrote: Here's a further update of what I'm thinking of with respect to $sth-more_results (many thanks for the valuable feedback). This is quite long because I've tried to consider all the issues. Anyone else got any comments? Tim.

Multiple result sets and the $sth-more_results method (Mark 3)

2004-05-04 Thread Tim Bunce
Here's a further update of what I'm thinking of with respect to $sth-more_results (many thanks for the valuable feedback). This is quite long because I've tried to consider all the issues. =head1 Multiple result sets and the $sth-more_results method There are 3 kinds of batches of SQL

RE: Multiple result sets and the $sth-more_results method (Mark 3)

2004-05-04 Thread Jeff Urlwin
This is quite long because I've tried to consider all the issues. Yes, you have. Sorry I couldn't respond to this earlier. =head2 Skipping Non-SELECT Results When executing stored procedures, for example, applications are sometimes only interested in the results of SELECT

Re: Multiple result sets and the $sth-more_results method (Mark 3)

2004-05-04 Thread Tim Bunce
On Tue, May 04, 2004 at 01:41:56PM -0400, Jeff Urlwin wrote: =head2 Skipping Non-SELECT Results When executing stored procedures, for example, applications are sometimes only interested in the results of SELECT statements executed by the procedure and not in any INSERTs, DELETEs,