[mapserver-users] Runtime Substitution error

[Stefanos Anastasiou]

Hello list,   I have a function stored in PostGIS in 'sql' language that performs pgRouting and returns the geometry of my road network as well. In the DATA section of the layer that renders this geometry, it is as follows:
   DATA "geom FROM (SELECT * FROM routing_function(%source%, %target%)) AS foo USING UNIQUE seq using srid=2100"
My VALIDATION section is in the layer level as:     VALIDATION             "source" "^[0-9]+$"            "target" "^[0-9]+$"       END
But the results are a bit weird...
In map mode:  if I pass the parameters in the url like ..&source=100&target=1000  I get a static map with my route correctly. In WMS request (as SERVICE=WMS&....&source=100&target=1000): it works fine as well returning a static image with the route.In browse mode:  the first time invoked the result is fine returning the route along with my template. But with the route already calculated, if I click on pan or zoom in for example, I get the following error in the MS_ERRORFILE: 
Error (ERROR:  syntax error at or near "%"LINE 1: ...hex') as geom,"seq" from (SELECT * FROM routing_function(%source%, ...
The same occurs also if I use the OpenLayers template like  ...&template=openlayers=&source=100&target=1000.
What am I missing here ?
Thank you very much.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20170116/fd097703/attachment.html>