[Mapserver-users] Re: trouble using FILTER in PostGIS query

[Jeff Hoffmann]

Jeff Hoffmann wrote:
> I'm trying to figure out how to set a FILTER on a PostGIS query based on 
> a query parameter passed in from the URL.  I tacked the parameter on the 
> end of the URL ("&pin=13929111046") then added the following line in the 
> mapfile:
>   FILTER "parcel = '%pin%'"
> but nothing happens.  When I looked at the actual query that is being 
> sent to the database, it appears that the "%pin%" never gets translated 
> into the value from the request.  Am I doing this right?  And if so, why 
> isn't it working?

I think I found the answer on my own.  I'm trying to do this with a WMS 
layer, which apparently isn't supported now (see 
http://lists.gis.umn.edu/pipermail/mapserver-dev/2003-January/000034.html).
Does anybody know if there is support for it yet in CVS?

-- 

Jeff Hoffmann
PropertyKey.com