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 = 0;

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) 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 tuples

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 returns: 3

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? That

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 values are valid

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 rows

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 =