[mapserver-users] Help with runtime variable substitution in inline ODBC virtual data sources

[pcreso at pcreso.com]

Hi,

I'm looking to set up a mapfile with an inline ovf data source as described in part 2 of section 5 at http://mapserver.org/input/vector/VirtualSpatialData.html

I'm also looking to embed an SQL in the ovf with a where clause, using runtime variable substitution as described at http://mapserver.org/cgi/runsub.html?highlight=variable

The latter says that such runtime substitution is supported in the CONNECTION & DATA fields within the LAYER object.

I'm unclear as to how a where clause can be inserted in the ovf definition, and am hoping that this will be in the CONNECTION or DATA fields, and is amenable to runtime variable substitution.

Basically with the URL including:                                         &job_id=23
have an ovf where clause specified like:      ...                    where job=%job_id%

 thus from this

have an ovf ODBC connection pass a where clause like:   and job_id=23 ..."  

This is connecting to an aspatial Oracle database returning up to 100 point features from a table with X Y columns..

Can anyone provide some hints on:

1. Is this possible?
2. How best to implement it?


Thanks,

   Brent Wood


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20110215/42d553da/attachment.html