note 73231 added to ref.mssql

From: Date: Wed, 14 Feb 2007 10:09:15 +0000
Subject: note 73231 added to ref.mssql
Groups: php.notes 
Request: Send a blank email to php-notes+get-123356@lists.php.net to get a copy of this message
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... ---- Server IP: 69.147.83.197 Probable Submitter: 212.154.187.238 (proxied: 1.0 CTR2K010) ---- Manual Page -- http://www.php.net/manual/en/ref.mssql.php Edit -- https://master.php.net/note/edit/73231 Del: integrated -- https://master.php.net/note/delete/73231/integrated Del: useless -- https://master.php.net/note/delete/73231/useless Del: bad code -- https://master.php.net/note/delete/73231/bad+code Del: spam -- https://master.php.net/note/delete/73231/spam Del: non-english -- https://master.php.net/note/delete/73231/non-english Del: in docs -- https://master.php.net/note/delete/73231/in+docs Del: other reasons-- https://master.php.net/note/delete/73231 Reject -- https://master.php.net/note/reject/73231 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#123356) next »