RE: [PHP-DB] MSSQL: Spaces in database name

I guess it would depend on your view of usability. To me, there's no shortage of "blanks" in the world, so I prefer to use them asOpposedToHopingTheCapitalizationIsPreserved kind of names. Once I finish designing an app *I* don't have to look at the names much, either, but I prefer the longer, natural-language friendly form when I come back a year later to do any needed maintenance. Old and forgetful, - Robert -----Original Message----- From: Miles Thompson [mailto:milesthompson@ns.sympatico.ca] Sent: Thursday, August 09, 2001 3:57 AM To: Robert D. Young; 'php-db@lists.php.net' Subject: RE: [PHP-DB] MSSQL: Spaces in database name 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