#34659 [Opn->Fbk]: mssql_query fails if you have triggers that return resultsets

From: Date: Tue, 27 Sep 2005 14:44:04 +0000
Subject: #34659 [Opn->Fbk]: mssql_query fails if you have triggers that return resultsets
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-85649@lists.php.net to get a copy of this message 
 ID:               34659
 Updated by:       fmk@php.net
 Reported By:      elite at programmer dot net
-Status:           Open
+Status:           Feedback
 Bug Type:         MSSQL related
 Operating System: Windows XP/2003
 PHP Version:      5CVS-2005-09-27 (snap)
 New Comment:

"Changed database context to '...'" is not generated by PHP but by the
database server. It's not an error but a message returned when the
current database context was changed.

Your example does not show how the function is failing. Please provide
an example that shows the trigger and the full PHP code so we can
reproduce the problem and fix the bug, if any.


Previous Comments:
------------------------------------------------------------------------

[2005-09-27 16:06:55] elite at programmer dot net

Description:
------------
When you execute a query, e.g. delete a row in a table that has
triggers AFTER DELETE and those triggers return resultsets (eg. SELECT
id FROM DELETED) PHP will report "Changed database context to '...'" 

Reproduce code:
---------------
mssql_query("DELETE row FROM table1");




------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=34659&edit=1

Thread (2 messages)

« previous php.bugs (#85649) next »