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.
>Any ideas...?

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to