[Mapserver-users] trouble using FILTER in PostGIS query

[Lowther, David W]

Jeff,

I don't know why, but I've had a lot more luck rewriting the entire DATA for
a PostGIS layer as opposed to setting the filter. Give it a shot, but be
aware that some newer versions of Mapserver come setup to NOT allow write of
data line. Someone else may be able to address this issue additionally.

David Lowther
Software Engineer
GEO Information Systems
University of Oklahoma
dlowther at ou.edu
(405) 325-3131
http://www.geo.ou.edu




> -----Original Message-----
> From: Jeff Hoffmann [mailto:jeff at propertykey.com] 
> Sent: Wednesday, May 21, 2003 10:57 AM
> To: mapserver-users at lists.gis.umn.edu
> Subject: [Mapserver-users] trouble using FILTER in PostGIS query
> 
> 
> 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?
> 
> -- 
> 
> Jeff Hoffmann
> PropertyKey.com
> 
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu 
> http://lists.gis.umn.edu/mailman/listinfo/maps> erver-users
>