[gdal-dev] [ OGR SQL: Excecuting select where column name starts with "_" SO: Windows 7, GDAL/OGR 1.9.x

2012-10-09 Thread Gabriel Fusca
Hi, I´m getting a sql parsing error when I tried to execute a query to a shapefile where column name starts with "_". When i execute a query like : ogrinfo Provincias.shp -sql "SELECT * FROM Provincias WHERE tipo = 1" INFO: Open of `Provincias.shp' using driver `ESRI Shapefile' successful.

Re: [gdal-dev] [ OGR SQL: Excecuting select where column name starts with "_" SO: Windows 7, GDAL/OGR 1.9.x

2012-10-11 Thread Etienne Tourigny
try enclosing the column with single or double quotes? On Tue, Oct 9, 2012 at 5:35 PM, Gabriel Fusca wrote: > > Hi, > > I´m getting a sql parsing error when I tried to execute a query to a > shapefile where column name starts with "_". > > When i execute a query like : ogrinfo Provincias.shp -sql