ID: 24496
Updated by: [EMAIL PROTECTED]
Reported By: mheuser at a-tune dot de
-Status: Open
+Status: Bogus
Bug Type: MSSQL related
Operating System: Windows 2000 SP4
PHP Version: 4.3.2
New Comment:
The MSSQL syntax for handling white spaces in identifiers is to use []
arround the name.
$dbDatabase = "[030616 [EMAIL PROTECTED] mhe]";
// or
$dbDatabase = "[EMAIL PROTECTED] mhe 030616]";
Will work.
Previous Comments:
------------------------------------------------------------------------
[2003-07-04 08:34:32] mheuser at a-tune dot de
Description:
------------
The mssql_select_db function does not accept any whitespaces in the
database name string nor decimal numbers at the front. If I replace the
whitespaces with something else (like _) and cut the numbers out or let
them trail the string, no error occurs and the command is performed
correctly.
The code line given in the error messages at the bottom of this page,
are actually in the PEAR::MDB package. I located the line in the source
code:
if(!mssql_select_db($this->database_name, $this->connection)) {
return($this->mssqlRaiseError());
}
Reproduce code:
---------------
$dbDatabase = "030616 [EMAIL PROTECTED] mhe";
// or
$dbDatabase = "[EMAIL PROTECTED] mhe 030616";
mssql_select_db($dbDatabase); // Connection to DBMS server was already
made successfully
Expected result:
----------------
I'd expect no error message which means a successfully selected
database.
Actual result:
--------------
// Error message
Warning: mssql_select_db(): message: Zeile 1: Falsche Syntax in der
Nähe von '030616'. (severity 15) in C:\PHP\pear\MDB\mssql.php on line
417
// and for the second example
Warning: mssql_select_db(): message: Zeile 1: Falsche Syntax in der
Nähe von 'mhe'. (severity 15) in C:\PHP\pear\MDB\mssql.php on line 417
In both examples the error occurs when calling mssql_select_db (see
description on top of this page for the source code line).
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=24496&edit=1
