[mapserver-users] Run time substitution - Like instead of =

[tellett]

Hi All,

I'm using runtime substitution to replace the value of an expression and
thats working fine, however, if I don't set the expression value in the url,
I want the layer to show all the records. For example my class looks likes
this:

CLASS
         NAME 'FKB-A'
         EXPRESSION '%pn%' 
         STYLE
            COLOR 254 150 254
            OUTLINECOLOR 1 1 1
         END
      END

and when I use this request:

.....REQUEST=GetMap&SERVICE=WMS&VERSION=1.3.0&LAYERS=fkb_prosjektstandard&STYLES=&FORMAT=image/png&BGCOLOR=0xFFFFFF&TRANSPARENT=TRUE&CRS=EPSG:4326&BBOX=58.9930983171506,9.40049150322111,59.8470137571506,10.904184647298&WIDTH=1650&HEIGHT=937&pn=LACHVE11

I get back 1 record which is correct. However, if I drop the &pn=LACHVE11 of
course I get no results back. Is there any way of changing this so that I
can get all the records of the table returned? 

I thought about using the 'default_pn' option in the metadata and using
wildcards but as this is an '=' expression rather than a 'LIKE' expression
wildcards are useless. Maybe its just because its friday afternoon, but I
just can't see a way of doing this, help!!!

Best Regards

Tom

--
View this message in context: http://osgeo-org.1560.n6.nabble.com/Run-time-substitution-Like-instead-of-tp4362317p4362317.html
Sent from the Mapserver - User mailing list archive at Nabble.com.