<head><title></title></head>
<body><div class="iw_mail" dir="ltr">Hi Marco,<br><br>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.<br><br>An example can be found in this discussion tread:<br><br><a href="https://lists.osgeo.org/pipermail/mapserver-users/2015-March/077583.html">https://lists.osgeo.org/pipermail/mapserver-users/2015-March/077583.html</a><br><br>Best regards<br><br>Lars S.<br><blockquote class="reply_block" dir="ltr" style="border-left: 2px solid blue; margin: 5pt 0 5pt 10pt; padding: 0 0 0 5pt; font-size: 13px; font-family: tahoma,helvetica,sans-serif;">
<hr size="1">-----Originalmeddelande-----<br>Från: "Marco Giana" <<a href="mailto:marco_giana@technologyonecorp.com">marco_giana@technologyonecorp.com</a>><br>Till: <a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>Datum: 2016-06-16 09:04<br>Ämne: [mapserver-users] CONNECTIONTYPE OGR use DIALECT SQLITE<br><br><div dir="ltr">Hi,<div><br></div>
<div>I have a layer config</div>
<div><br></div>
<div>
<div>CONNECTION "E:\\All\\Data\\Kingston\\VicMap\\Tab\\KINGSTON_LGA_POLYGON.tab"</div>
<div>CONNECTIONTYPE OGR</div>
<div>DATA "SELECT * FROM KINGSTON_LGA_POLYGON"</div>
<div><br></div>
<div>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?</div>
<div><br></div>
<div>Cheers</div>
<div><div class="gmail_signature" data-smartmail="gmail_signature"><p><font face="Arial, Verdana, Helvetica"><span style="font-size:10pt"><b>Marco Giana</b></span></font><br><br></p></div></div>
</div>
</div>
<hr>_______________________________________________<br>mapserver-users mailing list<br><a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a>
</blockquote>
<br><br><div class="signature"><div class="separator">--</div></div>
</div></body>