sql fieldname

[geraldjr30]

hi,

i have the following:

$sql="SELECT 'field name here', field2, age...

not sure how i would include a field name that contains spaces in the SELECT statement. I have an ODBC connection to MS Access..


Thanks

[Dormilich]

for this reason one usually does not use field names with spaces.... maybe escaping with a backslash, but I'm not sure

[Markus]

I think, but I'm not sure, you have to do it like this (if you have spaces in field names):

SELECT 
    `Column 1` AS Column_1
FROM
    ....

[Atli]

I remember the Microsoft SQL server GUI thing using brackets around field names.
Maybe that would work for Access as well?

Like:
[code=sql]SELECT [Field name] FROM [My table][/code]

[geraldjr30]

hi,

that 'field name' as field_name did not work.

In the meantime, I am just changing the table column names so they dont include spaces. But if i could figure out how to avoid changing table column names that would be helpful for those who insist that they not change.

thanks in advance,
geebee

[Atli]

Did you try the bracket thing I put in my last post?
According to what I've read that should work.

[geraldjr30]

thanks! the brackets worked.

[Markus]

Stupid me.. I overlooked the part about MS Access.

-_-

[Markus]

As a side note: in MySQL 5.0.27, you can have field names with spaces in them and select them as you would any other field.

SELECT
    `Field Column`
FROM
    `table`