[mapserver-users] Variables not processed in 6.0.2

[Hans]

hi

I am new in mapserver and testing with versions 5.2.2 and 6.2.0.

I found out that filtering in a layer with a url option does work in 5.2.2
but not in 6.2.0.

I have this layer :

   NAME demo
     STATUS ON
     TYPE POLYGON
	 
     METADATA
       'default_percsize' '1'
     END	 
	 
     CONNECTIONTYPE POSTGIS
     CONNECTION "host=192.168.3.8 dbname=postgis20 user=postgres
password=*** port=5432"
     DATA "geometry from map_05 using unique geb_id using srid=28992"
     FILTER  "perc_10 in ( %percsize% )" 

and there is "&percsize=10" in the url.

When using MapServ.exe 5.2.2. this works fine, but when using 6.2.0 it does
not process the percsize parameter from the URL when I see the error
message.

Failed to draw layer named 'demo'. msPostGISLayerWhichShapes(): Query error.
Error executing query: ERROR: syntax error at or near "%" LINE 1:
....8,-10179.25 306866.8))',28992) and (perc_10 in ( %percsize%... ^
msValidateParameter(): Regular expression error. Parameter pattern
validation failed. 

I see %percsize% is still in the SQL, so it was not replaced???

How can I fix this?

Hans




--
View this message in context: http://osgeo-org.1560.n6.nabble.com/Variables-not-processed-in-6-0-2-tp5027141.html
Sent from the Mapserver - User mailing list archive at Nabble.com.