Re: Is it correct that execute_array does not raise/print an error

2006-07-05 Thread Martin J. Evans
On 05-Jul-2006 Tim Bunce wrote: > On Wed, Jul 05, 2006 at 01:38:04PM +0100, Martin J. Evans wrote: >> Tim, >> >> Thanks for the clarification and "untested" patch. I've tried it and it now >> fails (returns undef) and the HandleError routine is called. The error I'm >> getting now is: >> >> exec

Re: Is it correct that execute_array does not raise/print an error

2006-07-05 Thread Tim Bunce
On Wed, Jul 05, 2006 at 01:38:04PM +0100, Martin J. Evans wrote: > Tim, > > Thanks for the clarification and "untested" patch. I've tried it and it now > fails (returns undef) and the HandleError routine is called. The error I'm > getting now is: > > executing ARRAY(0x8ce4c08) generated 1 D'oh.

Re: Is it correct that execute_array does not raise/print an error

2006-07-05 Thread Martin J. Evans
Tim, Thanks for the clarification and "untested" patch. I've tried it and it now fails (returns undef) and the HandleError routine is called. The error I'm getting now is: executing ARRAY(0x8ce4c08) generated 1 Changing your patch to: return $sth->set_err(1, "executing " . join(",", @{$tuple_st

Re: Is it correct that execute_array does not raise/print an error

2006-07-04 Thread Tim Bunce
On Tue, Jul 04, 2006 at 02:18:33PM +0100, Martin J. Evans wrote: > > Thanks for the explanation. You have not however convinced me this behavior is > right. If RaiseError caused a die on error and someone wanted to ignore errors > they could just do what they always do - turn RaiseError off and do

Re: Is it correct that execute_array does not raise/print an error

2006-07-04 Thread Dr.Ruud
"John Scoles" schreef: > As execute_array is normally use to inserts/update of millions of > records and with this volume you would not want your process to choke > on just one bad record Huh? It is fine if you can deliberately turn it off, but by default such a feature should abort and roll back

Re: Is it correct that execute_array does not raise/print an error

2006-07-04 Thread Martin J. Evans
document why I have this workaround. Martin -- Martin J. Evans Easysoft Ltd, UK http://www.easysoft.com > - Original Message - > From: "Martin J. Evans" <[EMAIL PROTECTED]> > To: > Sent: Tuesday, July 04, 2006 8:03 AM > Subject: Re: Is it correct that execute_

Re: Is it correct that execute_array does not raise/print an error

2006-07-04 Thread John Scoles
From: "Martin J. Evans" <[EMAIL PROTECTED]> To: Sent: Tuesday, July 04, 2006 8:03 AM Subject: Re: Is it correct that execute_array does not raise/print an error > > On 04-Jul-2006 John Scoles wrote: > > It memory serves me correctly I think any errors t

Re: Is it correct that execute_array does not raise/print an error

2006-07-04 Thread Martin J. Evans
error in methods except execute_array (and similarly for HandleError). Martin -- Martin J. Evans Easysoft Ltd, UK http://www.easysoft.com > > - Original Message - > From: "Martin J. Evans" <[EMAIL PROTECTED]> > To: > Sent: Tuesday, July 04, 2006 6:37 AM >

Re: Is it correct that execute_array does not raise/print an error

2006-07-04 Thread John Scoles
6:37 AM Subject: Is it correct that execute_array does not raise/print an error > Hi, > > I have some code which uses execute_array but it appears when it fails > my error handler is not called and no error is printed despite setting > PrintError and RaiseError. The script below ill

Is it correct that execute_array does not raise/print an error

2006-07-04 Thread Martin J. Evans
Hi, I have some code which uses execute_array but it appears when it fails my error handler is not called and no error is printed despite setting PrintError and RaiseError. The script below illustrates. Is it correct that an error can occur in execute_array and it not cause a die when RaiseError i