Hi Mike, Thanks for getting back to me. Worked a treat, thanks!!
Ended up with "prosjektnu = '%pn%' or '%pn%' = '\%pn\%'" on the filter Tom -----Opprinnelig melding----- Fra: Smith, Michael ERDC-CRREL-NH [mailto:[email protected]] Sendt: 3. februar 2012 17:57 Til: Thomas Ellett; [email protected] Emne: Re: [mapserver-users] Run time substitution - Like instead of = Tom, What I am using with a database connection is a default value of "1=1" so that is always true, it returns all records. Mike -- Michael Smith Remote Sensing/GIS Center US Army Corps of Engineers On 2/3/12 11:30 AM, "tellett" <[email protected]> wrote: >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_prosjektstanda rd& >STYLES=&FORMAT=image/png&BGCOLOR=0xFFFFFF&TRANSPARENT=TRUE&CRS=EPSG:432 6&B >BOX=58.9930983171506,9.40049150322111,59.8470137571506,10.904184647298& WID >TH=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. >_______________________________________________ >mapserver-users mailing list >[email protected] >http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
