Odd Ragnar Lydersen <Odd-Ragnar.Lydersen <at> powel.no> writes:
> > 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 I believe that . (dot) will not work in -sql in any place even it perhaps should. I made a small test feature type "dot.test" and the following is listing it >ogrinfo WFS:http://188.64.1.61/cgi-bin/tinyows This works too >ogrinfo WFS:http://188.64.1.61/cgi-bin/tinyows dot.test But this does not work >ogrinfo WFS:http://188.64.1.61/cgi-bin/tinyows -sql "select code_reg from >dot.test" The result is ERROR 1: SQL Expression Parsing Error: syntax error In my opinion using dots in feature type or field names is an intentional call for troubles but unfortunately -sql parameter seems to have troubles also with colons. This works for me >ogrinfo WFS:http://188.64.1.61/cgi-bin/tinyows -sql "select code_reg from >france" This should definitely work too, but it does not >ogrinfo WFS:http://188.64.1.61/cgi-bin/tinyows -sql "select code_reg from tows: france" INFO: Open of `WFS:http://188.64.1.61/cgi-bin/tinyows' using driver `WFS' successful. ERROR 1: SQL Expression Parsing Error: syntax error Tested with GDAL build from September 27th on Windows 7. -Jukka Rahkonen- _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev