[MapServer-dev] CONNECTIONTYPE OGR, specifying dialect?

[Scott]

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