note 81120 added to function.odbc-fetch-row
| From: | ben at imperialsoftwaresystems dot com | Date: | Thu, 14 Feb 2008 19:15:54 +0000 |
| Subject: | note 81120 added to function.odbc-fetch-row | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-136153@lists.php.net to get a copy of this message | ||
I traced out a problem to odbc_fetch_row hanging while trying to retrieve the 'row after the
last record'. Instead of simply returning false it would cause a timeout. This crept up after
a site I maintain recently converted from MS Access DB to MS SQL Server DB.
To work around the issue I first do 'select count(*) from blah'. I check that value as I
loop through the records, and once I reach the number of records specified by my count(*) I stop my
loop.
----
Server IP: 208.69.120.35
Probable Submitter: 69.114.37.173
----
Manual Page -- http://www.php.net/manual/en/function.odbc-fetch-row.php
Edit -- https://master.php.net/note/edit/81120
Del: integrated -- https://master.php.net/note/delete/81120/integrated
Del: useless -- https://master.php.net/note/delete/81120/useless
Del: bad code -- https://master.php.net/note/delete/81120/bad+code
Del: spam -- https://master.php.net/note/delete/81120/spam
Del: non-english -- https://master.php.net/note/delete/81120/non-english
Del: in docs -- https://master.php.net/note/delete/81120/in+docs
Del: other reasons-- https://master.php.net/note/delete/81120
Reject -- https://master.php.net/note/reject/81120
Search -- https://master.php.net/manage/user-notes.php