[mapserver-users] CONNECTIONTYPE OGR use DIALECT SQLITE

[lars.schylberg at blixtmail.se]

Hi Marco,

We ha a similar discussion last year.  I didn't find a direct way to specify sqlite dialect in the data statement.  You could however write it in a vrt file where You could set the sql dialect.

An example can be found in this discussion tread:

https://lists.osgeo.org/pipermail/mapserver-users/2015-March/077583.html

Best regards

Lars S.

-----Originalmeddelande-----
Från: "Marco Giana" <marco_giana at technologyonecorp.com>
Till: mapserver-users at lists.osgeo.org
Datum: 2016-06-16 09:04
Ämne: [mapserver-users] CONNECTIONTYPE OGR use DIALECT SQLITE

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?


Cheers

Marco Giana




_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

-- 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20160616/704fa8e8/attachment.htm>