[MapServer-dev] CONNECTIONTYPE OGR, specifying dialect?

[Scott]

Please disregard last email. That will NEVER work with a .fgb file. I 
tested with a .gpkg on the command line.

Apologies,
Scott

On 9/22/25 11:29, Scott via MapServer-dev wrote:
> Greetings,
> 
> My understanding is CONNECTIONTYPE OGR uses GDAL directly. Assuming 
> this, I'm trying to access the sqlite/spatialite dialect in the SQL 
> query below. Any option for setting dialect?
> 
> I've also tried an "<OGRVRTDataSource..." string in CONNECTION with 
> dialect="sqlite", no luck.
> 
> Yes, my libgdal is built with sqlite/spatialite.
> 
> The following runs without error, no errors/warnings in the log file. 
> All other layers render, but this layer does not. If I remove the DATA/ 
> query line it will render. Query runs fine with gdal ogr* command at the 
> command line (with -dialect sqlite)
> 
> Any suggestions?
> 
>     CONNECTIONTYPE OGR
>     CONNECTION "/path/to/data.fgb"
>     DATA "select
>         geom
>         ,st_area(geom) as area
>      from table"
>     CONNECTIONOPTIONS
>        "VERIFY_BUFFERS" "NO"
>     END
>     PROCESSING "CLOSE_CONNECTION=DEFER"
> 
> Thank you!
> Scott
> 
> -- 
> www.postholer.com
> 
> _______________________________________________
> MapServer-dev mailing list
> MapServer-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapserver-dev