[gdal-dev] SQL Expression post error

Even Rouault even.rouault at spatialys.com
Tue Jan 31 03:02:34 PST 2017


On mardi 31 janvier 2017 04:01:28 CET andreahmed wrote:
>  I get a SQL Expression parsing error
> 
>  OE_DEBUG << LC << "SQL: " << expr << std::endl;
>         _resultSetHandle = OGR_DS_ExecuteSQL( _dsHandle, expr.c_str(),
> _spatialFilter, 0L );
> 
> the expr is expr = "SELECT * FROM tows:poi_ais"
> 
> In the database the table name is poi_ais. The layer is tows. Is that a bug
> ?

towns:poi_ais needs to be escaped between double quotes

> 
> 
> 
> --
> View this message in context:
> http://osgeo-org.1560.x6.nabble.com/SQL-Expression-post-error-tp5305467.htm
> l Sent from the GDAL - Dev mailing list archive at Nabble.com.
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/gdal-dev


-- 
Spatialys - Geospatial professional services
http://www.spatialys.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20170131/aa0193e2/attachment.html>


More information about the gdal-dev mailing list