note 73231 added to ref.mssql
| From: | Ilyas at osu1 dot php dot net | 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