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:[EMAIL PROTECTED]]
>Sent: Tuesday, August 07, 2001 11:46 PM
>To: 'Robert D. Young'; '[EMAIL PROTECTED]'
>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:[EMAIL PROTECTED]]
>// Sent: Wednesday, 8 August 2001 2:39 PM
>// To: '[EMAIL PROTECTED]'
>// 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: [EMAIL PROTECTED]
>// For additional commands, e-mail: [EMAIL PROTECTED]
>// To contact the list administrators, e-mail:
>// [EMAIL PROTECTED]
>//
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
