Re: execute_array/execute_for_fetch (was: ANNOUNCE: Advanced DBI Tutorial Slides)

2006-09-06 Thread Tim Bunce
On Tue, Sep 05, 2006 at 09:13:04PM +0100, Martin J. Evans wrote: > On Tue, 2006-09-05 at 20:36 +0100, Tim Bunce wrote: > > > > @@ -1921,10 +1921,12 @@ > > # start with empty status array > > ($tuple_status) ? @$tuple_status = () : $tuple_status = []; > > > > + my $rc_total

Re: execute_array/execute_for_fetch (was: ANNOUNCE: Advanced DBI Tutorial Slides)

2006-09-05 Thread Martin J. Evans
On Tue, 2006-09-05 at 20:36 +0100, Tim Bunce wrote: > On Tue, Sep 05, 2006 at 02:10:24PM +0100, Martin J. Evans wrote: > > > > > > The DBIs default behaviour is the official behaviour. > > > > That is fair enough. I wasn't really suggesting it was changed, it was more > > of > > a pointing out t

Re: execute_array/execute_for_fetch (was: ANNOUNCE: Advanced DBI Tutorial Slides)

2006-09-05 Thread Tim Bunce
On Tue, Sep 05, 2006 at 02:10:24PM +0100, Martin J. Evans wrote: > > > > The DBIs default behaviour is the official behaviour. > > That is fair enough. I wasn't really suggesting it was changed, it was more of > a pointing out the inconvenience in case it led to a better way for me to get > the r

Re: execute_array/execute_for_fetch (was: ANNOUNCE: Advanced DBI Tutorial Slides)

2006-09-05 Thread Martin J. Evans
On 05-Sep-2006 Martin J. Evans wrote: > > On 05-Sep-2006 Tim Bunce wrote: >> On Tue, Sep 05, 2006 at 11:20:04AM +0100, Martin J. Evans wrote: >>> >>> I'll report the problems just as soon as I'm certain what they are. Here is >>> my summary: >>> >>> 1. insert into table values (?,?) where all v

RE: execute_array/execute_for_fetch (was: ANNOUNCE: Advanced DBI Tutorial Slides)

2006-09-05 Thread Ronald J Kimball
Tim Bunce [mailto:[EMAIL PROTECTED] wrote: > How about adding total rows affected as an extra return value in list > context?: > > ($tuples_executed, $rows_affected) = $sth->execute_array(...) How do you determine total rows affected? Is it simply the sum of rows affected for each tuple? Th

Re: execute_array/execute_for_fetch (was: ANNOUNCE: Advanced DBI Tutorial Slides)

2006-09-05 Thread Martin J. Evans
On 05-Sep-2006 Tim Bunce wrote: > On Tue, Sep 05, 2006 at 11:20:04AM +0100, Martin J. Evans wrote: >> >> I'll report the problems just as soon as I'm certain what they are. Here is >> my summary: >> >> 1. insert into table values (?,?) where all values are valid and 3 rows of >>values >> >>

Re: execute_array/execute_for_fetch (was: ANNOUNCE: Advanced DBI Tutorial Slides)

2006-09-05 Thread Tim Bunce
On Tue, Sep 05, 2006 at 11:20:04AM +0100, Martin J. Evans wrote: > > I'll report the problems just as soon as I'm certain what they are. Here is > my summary: > > 1. insert into table values (?,?) where all values are valid and 3 rows of >values > > returns: 3 >(correct as 3 tup

RE: execute_array/execute_for_fetch (was: ANNOUNCE: Advanced DBI Tutorial Slides)

2006-09-05 Thread Martin J. Evans
On 04-Sep-2006 Tim Bunce wrote: > On Mon, Sep 04, 2006 at 05:21:17PM +0100, Martin J. Evans wrote: >> >> It did raise an issue where I could do with some clarification. The slides >> say: >> >> Execute a statement for multiple values >>$sth = $dbh->prepare("insert into table (foo,bar) value

execute_array/execute_for_fetch (was: ANNOUNCE: Advanced DBI Tutorial Slides)

2006-09-04 Thread Tim Bunce
On Mon, Sep 04, 2006 at 05:21:17PM +0100, Martin J. Evans wrote: > > It did raise an issue where I could do with some clarification. The slides > say: > > Execute a statement for multiple values >$sth = $dbh->prepare("insert into table (foo,bar) values (?,?)"); >$tuples = $sth->execute_