RE: [PHP-DB] MSSQL: Spaces in database name
| From: | Miles Thompson | Date: | Thu, 09 Aug 2001 10:56:49 +0000 |
| Subject: | RE: [PHP-DB] MSSQL: Spaces in database name | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-11170@lists.php.net to get a copy of this message | ||
Why have spaces in names at all? To me it's long term aggravation, unnecessary keystrokes, and a future source of bugs. Besides, the end user rarely sees these names. Another case of do it just because you can?
If this is an inherited database, my apologies. If you are just starting the project I beg you to reconsider now.
Curmudgeonly yours - Miles Thompson
At 07:22 PM 8/8/01 -0700, Robert D. Young wrote:
That did it! Using: <... stuff > $dbname = "[Test Database]"; <... more stuff > mssql_select_db($dbname); worked perfectly. Again, Thanks! - Robert -----Original Message----- From: Beau Lebens [mailto:B.Lebens@curtin.edu.au] Sent: Tuesday, August 07, 2001 11:46 PM To: 'Robert D. Young'; 'php-db@lists.php.net' Subject: RE: [PHP-DB] MSSQL: Spaces in database name i noticed in teh sql of working with some apps that it does things like [Test Database].fieldname that might work :) HTH Beau // -----Original Message----- // From: Robert D. Young [mailto:Robert@AbilitySys.com] // Sent: Wednesday, 8 August 2001 2:39 PM // To: 'php-db@lists.php.net' // Subject: [PHP-DB] MSSQL: Spaces in database name // // // How can I get mssql_select_db to accept a database name with // spaces in it? // For example, this: // // <... stuff > // $dbname = "Test Database"; // <... more stuff > // mssql_select_db($dbname); // // doesn't work. But if I change to a database with no space in // the name (like // "Test_Database") it works fine. Other apps (Access, SQL // Admin, etc.) have no // problems with a database with a space in the name. // // - Robert // // // -- // PHP Database Mailing List (http://www.php.net/) // To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net // For additional commands, e-mail: php-db-help@lists.php.net // To contact the list administrators, e-mail: // php-list-admin@lists.php.net // -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net