Understood. Notice that almost all of the MS databases and tables
(predefined and samples) have *no* space in them. I'd long ago forgotten the
ODBC/SQL syntax (last time I used it was in 95), thanks for the reminder.

- Robert
  (who likes to use human readable names wherever possible)

-----Original Message-----
From: Graeme Merrall [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 08, 2001 8:19 PM
To: Robert D. Young
Cc: 'Beau Lebens'; '[EMAIL PROTECTED]'
Subject: RE: [PHP-DB] MSSQL: Spaces in database name

Quoting "Robert D. Young" <[EMAIL PROTECTED]>:

> That did it! Using:
> <... stuff >
> $dbname = "[Test Database]"; 
> <... more stuff >
> mssql_select_db($dbname);
> worked perfectly. Again, Thanks!

This is standard Microsoft (and maybe ODBC?) syntax. Using square brackets
work on most things including table names and field names with spaces in
This will work fine

SELECT [table space].[field space] FROM [table space]

It doesn't mean that you should go around putting spaces in your database 
objects. That's never a good idea :)


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]

Reply via email to