Even Rouault wrote:
Selon Jukka Rahkonen <[email protected]>: >> > 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 >> >> >> Sorry for the undue judgement. This is the correct way to do it on Windows >> >> >ogrinfo WFS:http://188.64.1.61/cgi-bin/tinyows -sql "select 'nom.dept' from >> 'tows:dot.test'" >> >> It is just always as hard for me to remember the right syntax. > OGR SQL follows SQL on this : column and table/layer names are identifiers. So > they must start with a letter or underscore, and subsequent characters must be > letters, underscores or digits. If the identifier is more complex than that, > it > must be quoted. To follow SQL, it is recommended to you double-quote > characters, > which might require SHELL escaping since they are already in a double-quoted > string, like : > ogrinfo poly.shp -sql "select "eas_id" from "poly"" Yes, that's a good theory but it is not easy to use it on Windows. Does anybody in the world know how should this one be escaped? I have already tried to use ^" as inner double quotes but without success, as well as having two ^^ and three ^^^. gdal_dev>ogrinfo WFS:http://188.64.1.61/cgi-bin/tinyows -sql "select "nom.dept" from "tows:dot.test"" INFO: Open of `WFS:http://188.64.1.61/cgi-bin/tinyows' using driver `WFS' successful. ERROR 1: SQL Expression Parsing Error: syntax error > OGR currently also accepts quoting of column/table names with single-quote > character (which is normally reserved for string literals), but this can lead > to > some ambiguity. If you use 'foo', OGR will currently choose the column name > foo > if it exists, instead of the string literal 'foo' as standard SQL would > mandate. > > -Jukka- > > _______________________________________________ > gdal-dev mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/gdal-dev > _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
