note 23091 added to function.sybase-query
| From: | dabratt at ifrance dot com | Date: | Tue, 09 Jul 2002 10:00:59 +0000 |
| Subject: | note 23091 added to function.sybase-query | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-32788@lists.php.net to get a copy of this message | ||
Strange problem... I'm accessing a SQL SERVER 2000 database through freetds with php v4.0.1pl2
on linux.
Thoses instructions work fine :
// Just a test
sybase_query("SELECT MES_ID FROM T_MESSAGE", $dbproc);
// data i want to retrieve, stored procedure
$resConfig = sybase_query("exec P_SLC_EMAILCONFIG", $dbproc);
$arrConfig = sybase_fetch_array($resConfig);
But, when i replace the SELECT statement by an UPDATE statement, i.e:
// Here's the update
sybase_query("UPDATE T_MESSAGE SET MES_STATE = 0", $dbproc);
// data i want to retrieve, stored procedure
$resConfig = sybase_query("exec P_SLC_EMAILCONFIG", $dbproc);
$arrConfig = sybase_fetch_array($resConfig);
Then i've got an error : "Supplied argument is not a valide Sybase result resource.."
on the line containing the sybase_fetch_array command.
I don't understand why... I have to close and reopen the connection if i want those lines to
work!!!
--
http://www.php.net/manual/en/function.sybase-query.php
http://master.php.net/manage/user-notes.php?action=edit+23091
http://master.php.net/manage/user-notes.php?action=delete+23091
http://master.php.net/manage/user-notes.php?action=reject+23091