php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #31532 delete query failed
Submitted: 2005-01-13 10:32 UTC Modified: 2005-01-13 21:11 UTC
Votes:2
Avg. Score:5.0 ± 0.0
Reproduced:0 of 0 (0.0%)
From: nikanorov at gmail dot com Assigned:
Status: Closed Package: MSSQL related
PHP Version: 4.3.10 OS: windows xp
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: nikanorov at gmail dot com
New email:
PHP Version: OS:

 

 [2005-01-13 10:32 UTC] 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'.)

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-01-13 21:11 UTC] derick@php.net
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.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Fri Mar 29 02:01:30 2024 UTC