[gdal-dev] OGR SQL: Excecuting select where column name contains "."

[Odd Ragnar Lydersen]

When I use single quotes, I get no errors, but instead I get returned the column name = FIELD_1, and all values = column.name.one
I'm using the ExecuteSql() on a WFS datasource, so it might be the WFS driver which causes the undesired FIELD_1 result.

>Odd-Ragnar<

-----Original Message-----
From: Jeff Lake [mailto:admin at michiganwxsystem.com] 
Sent: 4. oktober 2012 14:11
To: Odd Ragnar Lydersen
Subject: Re: [gdal-dev] OGR SQL: Excecuting select where column name contains "."

use single quotes
eg 'column.name.one'

-Jeff Lake
MichiganWxSystem.com
AllisonHouse.com
TheWeatherCenter.net
GRLevelXStuff.com

On 10/4/2012 7:29, Odd Ragnar Lydersen wrote:
> Is it possible to make OGRDataSource:: ExecuteSQL() to work with a column name containing "."?
>
> Here is an example:
> select column.name.one, column.name.two from 'wfs:layerName'
>
> I have tried to enclose the column name in [] brackets, but that was invalid as well.
> Any ideas on how to get around this?
>
>> Odd-Ragnar<
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>