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" <[email protected]> Till: [email protected] 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 [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users --
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
