#31532 [Opn->Csd]: delete query failed
| From: | derick@php.net | Date: | Thu, 13 Jan 2005 20:11:03 +0000 |
| Subject: | #31532 [Opn->Csd]: delete query failed | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-72087@lists.php.net to get a copy of this message | ||
ID: 31532
Updated by: derick@php.net
Reported By: nikanorov at gmail dot com
-Status: Open
+Status: Closed
Bug Type: MSSQL related
Operating System: windows xp
PHP Version: 4.3.10
New Comment:
This bug has been fixed in CVS.
Snapshots of the sources are packaged every three hours; this change
will be in the next snapshot. You can grab the snapshot at
http://snaps.php.net/.
Thank you for the report, and for helping us make PHP better.
Previous Comments:
------------------------------------------------------------------------
[2005-01-13 10:32:13] nikanorov at gmail dot com
Description:
------------
On delete return -- "Changed database context to 'wakka'". SQL query
runs on SERVER, but mssql_query returns false.
This sql in Query Analizer works fine.
Server: IIS 5
MSSQL: MSSQL DEV 2000 SP3
RESULT OF EXAMPLE CODE: Query failed: delete from wakka_links where
from_tag = 'HomePage' (Changed database context to 'wakka'.)
Reproduce code:
---------------
<?
$sql="delete from wakka_links where from_tag = 'HomePage'";
$dblink = mssql_connect('localhost', 'sa', 'pass');
mssql_select_db('wakka', $dblink);
if (!$result = mssql_query($sql, $dblink))
{
die("Query failed: ".$sql." (".mssql_get_last_message().")");
}
?>
Actual result:
--------------
Query failed: delete from wakka_links where from_tag = 'HomePage'
(Changed database context to 'wakka'.)
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=31532&edit=1