[mapserver-users] Variables not processed in 6.0.2 CRM:0001794

[Hans]

Thank you for you're help.
You are right.
Adding a validation did work.

Kind regards
Hans 
-----Original Message-----
From: Rahkonen Jukka [mailto:Jukka.Rahkonen at mmmtike.fi] 
Sent: zondag 13 januari 2013 11:18
To: Hans; mapserver-users at lists.osgeo.org
Subject: Re: [mapserver-users] Variables not processed in 6.0.2

Hi,

Validation became compulsory in version 6.0. Read
http://mapserver.org/cgi/runsub.html#validation and add validation block for
percsize.

-Jukka Rahkonen-
________________________________________
Hans wrote:

> 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-tp50271
41.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 2986 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20130114/d8ae22d9/attachment.bin>