UBB.Developers Forums Community Development Programming PHP and Server-side Scripting Infinite Loop Dilemma

I have a Perl script. When I run it, it processes for about 15 minutes, then Perl crashes.

I'm running the script on Windows Me, using Personal Web Server. Everything else, including UBB, runs fine, so I don't think it's a server configuration problem.

The script accesses an MS Access database using Win32::oDBC. There is a while loop, which is supposed to process each record returned by the Sql query. When I remove the while loop, the script functions without a problem, so I think the problem is an infinite loop of some kind.

Are there any precautions I can take to ensure that the while loop stops when it should do?

I'm using the $dbase->FetchRow() command to control the loop.

Any help and suggestions are appreciated

SF

I'd have to see the returned result set, and the loop.

--mark

Ooohhh... trout slaps self.

I was just looking through the code once more before posting it, and I found this line:


No wonder it was looping... someone must have slipped me a tranquiliser...

Sorry!