From: mheuser at a-tune dot de
Operating system: Windows 2000 SP4
PHP version: 4.3.2
PHP Bug Type: MSSQL related
Bug description: mssql_select_db doesn't accept database names with whitespaces
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 bug report at http://bugs.php.net/?id=24496&edit=1
--
Try a CVS snapshot: http://bugs.php.net/fix.php?id=24496&r=trysnapshot
Fixed in CVS: http://bugs.php.net/fix.php?id=24496&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=24496&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=24496&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=24496&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=24496&r=support
Expected behavior: http://bugs.php.net/fix.php?id=24496&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=24496&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=24496&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=24496&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=24496&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=24496&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=24496&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=24496&r=gnused
