note 73231 deleted from ref.mssql by tularis
| From: | tularis@php.net | Date: | Wed, 14 Feb 2007 10:49:07 +0000 |
| Subject: | note 73231 deleted from ref.mssql by tularis | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-123362@lists.php.net to get a copy of this message | ||
Note Submitter: Ilyas
----
Found a problem that i can't explain. maybe bug.
I have PHP 4.4.1 on IIS installed. and working with remote MSSQL server.
I'm trying to execute stored procedure on MSSQL and all run great until the TABLE will have
trigger inside. After this any INSERT query in this table will damage other querys to MSSQL that
going after that INSERT query.
here is the code and answer from PHP
mssql_connect($server, $login, $pwd);
mssql_select_db($db);
$stmt=mssql_init("TABLE_WITH_TRIGGER_INSERT");
$val=0;
mssql_bind($stmt,"@PARAM1" ,$val,SQLINT4);
$result=mssql_execute($stmt);
$row=mssql_fetch_row($result);
echo($row[0]);
mssql_close();
mssql_connect($server, $login, $pwd);
mssql_select_db($db);
mssql_query("select * from OTHERTABLE ");
THE PHP RETURN ERROR ON LAST LINE...