tables/columns with spaces
| From: | Jeffrey_N_Dyke at Keane dot com | Date: | Fri, 10 May 2002 12:41:11 +0000 |
| Subject: | tables/columns with spaces | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-19099@lists.php.net to get a copy of this message | ||
Someone, in their infinite wisdom, named some, not all of course, tables
and columns with spaces, i.e. BUSINESS AREA in a SQL server database that i
am working with. You can run lots of queries that return fine, but when I
run a query such as "select * from REQ where BUSINESS AREA = '$var', i get
an error. Which, to me is completely understandable. I have tried using
the [BUSINESS AREA] notation, which will work on tables named with spaces,
but not field names.
I want to simply rename, and make the others adapt their code to conform.
But i wanted to try to solve this first.
Any ideas...?
Thanks,
Jeff