note 23091 added to function.sybase-query

From: 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

« previous php.notes (#32788) next »