note 48345 added to function.odbc-free-result
| From: | rich at kastle dot com | Date: | Mon, 20 Dec 2004 11:48:28 +0000 |
| Subject: | note 48345 added to function.odbc-free-result | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-82077@lists.php.net to get a copy of this message | ||
("Note: If auto-commit is disabled (see odbc_autocommit()) and you call odbc_free_result()
before committing, all pending transactions are rolled back.")
I've looked thru the code, and that note is definitely wrong, at least in my environment
(Windows/SQL Server). odbc_free_result ultimately just calls SQLFreeStmt which has NO EFFECT on
outstanding transactions.
In fact, it seems it must be wrong for all environments, because the SQLFreeStmt is bound to the
destruction of the result resource. So unset($result) would be just as dangerous - and you're
randomly and unpredictably screwed if garbage collection reaps the result set before your
transaction's done.
----
Manual Page -- http://www.php.net/manual/en/function.odbc-free-result.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+48345
Delete -- http://master.php.net/manage/user-notes.php?action=delete+48345&report=yes
Reason: bad code -- http://master.php.net/manage/user-notes.php?action=delete+48345&report=yes&reason=bad+code
Reason: spam -- http://master.php.net/manage/user-notes.php?action=delete+48345&report=yes&reason=spam
Reason: useless example -- http://master.php.net/manage/user-notes.php?action=delete+48345&report=yes&reason=useless+example
Reason: contains commercial links -- http://master.php.net/manage/user-notes.php?action=delete+48345&report=yes&reason=contains+commercial+links
Reason: useless note -- http://master.php.net/manage/user-notes.php?action=delete+48345&report=yes&reason=useless+note
Reject -- http://master.php.net/manage/user-notes.php?action=reject+48345&report=yes
Search -- http://master.php.net/manage/user-notes.php