RE: Retrying a fetch after an error, without restarting the whole loop?

2006-11-09 Thread Garrett, Philip \(MAN-Corporate\)
Jonathan Leffler wrote: On 11/8/06, Bart Lateur [EMAIL PROTECTED] wrote: [snip] 1) What's the best way to temporarily disable RaiseError when I want to have it enabled for the rest of the script? Say, for one SQL statement? $sth-{RaiseError} = 0; Or: $dbh-{RaiseError} = 0;

Re: Retrying a fetch after an error, without restarting the whole loop?

2006-11-09 Thread Bart Lateur
On Wed, 8 Nov 2006 23:26:02 -0800, Jonathan Leffler wrote: And 2), in a fetch loop, is it possible to adjust a property like {ReadLongLen}, and retry the same fetch without restarting the whole loop? Because this error typically happened several minutes into the loop. Highly unlikely. The

Re: Retrying a fetch after an error, without restarting the whole loop?

2006-11-09 Thread Jonathan Leffler
On 11/9/06, Bart Lateur [EMAIL PROTECTED] wrote: On Wed, 8 Nov 2006 23:26:02 -0800, Jonathan Leffler wrote: Bart Lateur [EMAIL PROTECTED] asked: And 2), in a fetch loop, is it possible to adjust a property like {ReadLongLen}, and retry the same fetch without restarting the whole loop?

Re: Retrying a fetch after an error, without restarting the whole loop?

2006-11-08 Thread Jonathan Leffler
On 11/8/06, Bart Lateur [EMAIL PROTECTED] wrote: I've been saving picture files that had been stored in a blob field in an MS-Access database (aka an OLE Object) to files, and I've bumped onto some LongReadLen related problems: through trial and error I finally succeeded in making LongreadLen