[mapserver-users] Passing an additional parameter via URL for WMS request - doesn't work anymore with new mapserver?

[thomas bonfort]

http://mapserver.org/cgi/runsub.html#validation

On Tue, Aug 21, 2012 at 4:07 PM, Stefan Schwarzer
<stefan.schwarzer at unep.org> 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
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users