http://mapserver.org/cgi/runsub.html#validation
On Tue, Aug 21, 2012 at 4:07 PM, Stefan Schwarzer <[email protected]> wrote: > Hi there, > > I used to pass a parameter in a WMS request in order to specify which country > should be highlighted. The MAPFILE would read that and, via an EXPRESSION, > set all country but the selected one to a bit of opacity: > > DATA "the_geom FROM (SELECT xxx FROM capitals WHERE > capitals.id_country <> %id_country%) AS foo USING UNIQUE gid USING srid=4326" > > That doesn't work anymore after upgrading our machine. So, I am not 100% sure > if this comes from mapserver, or if there is anything else involved. But it > seems more like a mapserver problem, as the error-message is > > <ServiceException> > msDrawMap(): Image handling error. Failed to draw layer named > 'capitals_selected'. > msPostGISLayerWhichShapes(): Query error. Error executing query: ERROR: > syntax error at or near "%" > LINE 1: ...als.gid FROM capitals WHERE capitals.id_country = %id_countr... > ^ > > msValidateParameter(): Regular expression error. Parameter pattern validation > failed. > msValidateParameter(): Regular expression error. Parameter pattern validation > failed. > msValidateParameter(): Regular expression error. Parameter pattern validation > failed. > msValidateParameter(): Regular expression error. Parameter pattern validation > failed. > </ServiceException> > > > Thanks for any hints/clarification. > > Stefan > _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
