[mapserver-users] Run time substitution - Like instead of =
Smith, Michael ERDC-CRREL-NH
Michael.Smith at usace.army.mil
Fri Feb 3 11:56:46 EST 2012
What I am using with a database connection is a default value of "1=1" so
that is always true, it returns all records.
Remote Sensing/GIS Center
US Army Corps of Engineers
On 2/3/12 11:30 AM, "tellett" <thomas.ellett at statkart.no> wrote:
>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
>I want the layer to show all the records. For example my class looks likes
> NAME 'FKB-A'
> EXPRESSION '%pn%'
> COLOR 254 150 254
> OUTLINECOLOR 1 1 1
>and when I use this request:
>I get back 1 record which is correct. However, if I drop the &pn=LACHVE11
>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!!!
>View this message in context:
>Sent from the Mapserver - User mailing list archive at Nabble.com.
>mapserver-users mailing list
>mapserver-users at lists.osgeo.org
More information about the mapserver-users