Dynamic where clause in OGR/ OVF file

Shanton, James A James.Shanton2 at NSCORP.COM
Thu Dec 30 04:17:09 PST 2004


Is it Possible to put asp or other dynamic content in an OGR file ?

(Specifically the where clause of the SQL statement )

In my Sample below I'd like to replace the '%myuid' in the SQL with the
users id  -- something like <%session("myuid")%>


<OGRVRTDataSource>
    <OGRVRTLayer name="notesogrl">
        <SrcDataSource>ODBC:dbuid/mypwd at mydsn</SrcDataSource>
        <SrcLayer>mynotes</SrcLayer>
       <SrcSQL>select icon_id,gis_note,latitude as y,longitude as
x,insert_id from gis_object where insert_id like '%myuid'</SrcSQL>
        <GeometryType>wkbPoint</GeometryType>
        <LayerSRS>WGS84</LayerSRS>
        <GeometryField encoding="PointFromColumns" x="x" y="y"/>
    </OGRVRTLayer>
</OGRVRTDataSource>



More information about the MapServer-users mailing list