note 15577 rejected and deleted from ref.mssql by zak
| From: | zak@php.net | Date: | Tue, 18 Sep 2001 13:53:40 +0000 |
| Subject: | note 15577 rejected and deleted from ref.mssql by zak | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-18125@lists.php.net to get a copy of this message | ||
I'm using MSSQL 7.0 on WinNT4.0, FreeTDS 0.51 with tdsver=4.2, client is
SuSe Linux 7.1, Apache 1.3.19, PHP 4.0.6.
I've run into troubles while checking SELECT permissions for several
tables within a single db connection. In a typical case, I think, this
should work fine:
##################################################
$php_errormsg = '';
@mssql_query("SELECT * FROM $table");
if (!empty($php_errormsg)) {
echo "It seems you cannot access table $table";
}
##################################################
But this code works only the first time within a single connection to
MSSQL server. The 2nd call to such a code does nothing with the contents
of $php_errormsg, even when there should be message 'Permission denied'.
(Sometimes the next call to mssql_query without '@' fires the exception.)
I've also tried a piece of code like this, but the result was the same:
##################################################
$php_errormsg = '';
$result = mssql_query("SELECT * FROM $table");
if (! $result) {
echo "It seems you cannot access table $table";
}
##################################################
It seems to me, that there is a bug somewhere. Any help?