in reply to fetchrow_array loop in perl 5.10

You expect people to determine from deep understanding of the code why your program doesn't work.

I view programming the other way around ..... it doesn't work? What is the return value of execute()? What does DBI::errstr() return? If you run the program in the debugger, what happens in the first ( and only successful ) execute()? Is there a second execute() attempted but it fails? Or does the loop terminate after the first execute?

As Occam said: Entia non sunt multiplicanda praeter necessitatem.

Replies are listed 'Best First'.
Re^2: fetchrow_array loop in perl 5.10
by Anonymous Monk on Sep 19, 2014 at 08:50 UTC
    errstr has no value for every after line, the issue here is that the loop (fetchrow_array) ends after 2 rows (out of 4) always. again the code perfectly works before the perl upgrade.

      If there are no errors but the loop ends unexpectedly, have you checked to see that the loop conditional is what you expect?