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 
&#39;capitals_selected&#39;.
msPostGISLayerWhichShapes(): Query error. Error executing query: ERROR:  syntax 
error at or near &quot;%&quot;
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

Reply via email to