SQL WHERE in OGR VRT
David.Fawcett at STATE.MN.US
Wed Apr 27 16:59:51 EDT 2005
What is the lowest MapServer Version where SQL WHERE is supported in ORG VRT's?
I am playing with a virtual layer that connects to an Access database using OGR. The layer works great when I use <SrcLayer>tlkpDestFac</SrcLayer> and call up all of the elements in the file.
I attempted to filter the layer by using <SrcSQL>SELECT FClass, UTMX, UTMY, NameShort FROM tlkpDestFac WHERE FClass = 1</SrcSQL> in place of <SrcLayer> . Using the MapServer 4.4.1 binary from MapTools, I get the error ' msDrawMap(): Image handling error. Failed to draw layer named 'facilities'.
msOGRFileOpen(): OGR error. Open failed for OGR connection `facslf.ovf'. Failed to import LayerSRS `epsg:32615'. '
If I hit the same .ovf file with ogrinfo 1.2.5+ in the FW Tools package, it is read just fine.
Minnesota Office of Environmental Assistance
david.fawcett at moea.state.mn.us
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the mapserver-users