Try using quotation marks:
select * from REQ where "BUSINESS AREA" = '$var'
Keep in mind that using quotation marks means that the field name is
now case sensitive.
OpenLink Software Inc.
On Fri, 10 May 2002 08:41:11 -0400, [EMAIL PROTECTED] (Jeffrey
N Dyke) wrote:
>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.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php