I have been using variable substitution for ages without any problems at all but now need to make a change to add a new variable.
I just cannot make it work. Presumably, I am doing something stupid but I cannot see what. Can anybody please help. My URL looks like this: http://www.agua.com.au/benparts/map.html?map=/tmp/11_70.map&client=70&mapext=140.5261724+-36.7067416+140.5485957+-36.6984975 &mre=-1296538.11+-4230140.65+62672.87+-2872042.86&pfilter=pid+in+(select+probe.id+from+probe+where+logger_id+in+(select+id+from+logger+where+client_id=70)) (plus a deal more filter definitions). My map file looks like this: LAYER CONNECTIONTYPE postgis NAME "probe" DATA "geom from atp using unique id using SRID=4283" CONNECTION "user=scldad dbname=benparts" PROCESSING "CLOSE_CONNECTION=DEFER" STATUS ON TYPE POINT FILTER (%pfilter%) PROJECTION "init=epsg:4283" END MAXSCALE 5000000 LABELITEM "temp" CLASS NAME "Air Temp (Right Click to select)" STYLE COLOR 255 255 0 SYMBOL 'circle' SIZE 7 END LABEL MINDISTANCE 15 POSITION CR SIZE SMALL BACKGROUNDCOLOR 0 0 0 COLOR 255 255 0 FORCE TRUE END END END This works as I expect. I now want to add a new filter by adding: &ffilter=blah_blah to the URL and a new layer with the same syntax as above (but with the new filter) to the map file. Despite trying a number of variations on the theme, my PostgreSQL log still shows a generated command that included %ffilter% instead of the substitution value. TIA, Stephen Davies -- ======================================================================== This email is for the person(s) identified above, and is confidential to the sender and the person(s). No one else is authorised to use or disseminate this email or its contents. Stephen Davies Consulting Voice: 08-8177 1595 Adelaide, South Australia. Fax: 08-8177 0133 Computing & Network solutions. Mobile:0403 0405 83 _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
