[mapserver-users] CONNECTIONTYPE OGR use DIALECT SQLITE

[Marco Giana]

Hi Even,

thanks for the reply. I was meaning to be able to use it on other file
types, such as shape and TAB, as one would specify
-dialect SQLITE when doing ogrinfo.

Cheers

* Marco Giana*
On Thu, Jun 16, 2016 at 9:59 PM, Even Rouault <even.rouault at spatialys.com>
wrote:

> Le jeudi 16 juin 2016 09:04:00, Marco Giana a écrit :
> > Hi,
> >
> > I have a layer config
> >
> > CONNECTION
> "E:\\All\\Data\\Kingston\\VicMap\\Tab\\KINGSTON_LGA_POLYGON.tab"
> > CONNECTIONTYPE OGR
> > DATA "SELECT * FROM KINGSTON_LGA_POLYGON"
> >
> > wondering, is it possible set DIALECT SQLITE in the MapFile to be able to
> > use spatialite SQL rather than OGR_SQL in the DATA tag?
>
> That should work. OGR_DS_ExecuteSQL() is run without any explicit dialect,
> so
> it is the default dialect of each OGR driver that is used, and in the case
> of
> SQLite/Spatialite, it will evaluated by SQLite itself.
>
> >
> > Cheers
> >
> > * Marco Giana*
>
> --
> Spatialys - Geospatial professional services
> http://www.spatialys.com
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20160616/4954824b/attachment.htm>