[mapserver-users] Problem with Variable Substitution for EXPRESSION

[Lime, Steve D (DNR)]

See http://www.regular-expressions.info/floatingpoint.html for some good examples.

Steve

From: mapserver-users-bounces at lists.osgeo.org [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Prabu Raja
Sent: Tuesday, November 15, 2011 4:29 AM
To: mapserver-users at lists.osgeo.org
Subject: [mapserver-users] Problem with Variable Substitution for EXPRESSION

Hi,

I need to compare one attribute from database table in "EXPRESSION" (under "LAYER") with six different values passed as Variable Substitution  for coloring the layer.

I did added validation for those variables in the map file, but for some reason I am getting the below error.

msValidateParameter(): Regular expression error. Parameter pattern validation failed.
msEvalRegex(): Regular expression error. String failed expression test.
msValidateParameter(): Regular expression error. Parameter pattern validation failed.

Could anyone help me with where I am wrong? Below is the map file content for this layer.

All the six variables would be numbers (may be a decimal number), Is my regular expression correct?

WEB
   VALIDATION
      value_one     "^[\d+(\.\d)]*$"
      value_two     "^[\d+(\.\d)]*$"
      value_three   "[^\d+(\.\d)]*$"
      value_four    "[^\d+(\.\d)]*$"
      value_five    "[^\d+(\.\d)]*$"
      value_six     "[^\d+(\.\d)]*$"
   END
END

LAYER
   NAME "state"
   TYPE polygon
   STATUS ON
   CONNECTIONTYPE POSTGIS
   CONNECTION  "user=postgres password=****** dbname=shpdb host=localhost port=5432"
   DATA "the_geom FROM  (SELECT gid, the_geom, totpop1 FROM state_shape) AS SUBQUERY using unique gid"
   PROCESSING "CLOSE_CONNECTION=DEFER"
   CLASSITEM "totpop1"
   OPACITY 100
   CLASS
 EXPRESSION ([TOTPOP1] >= %value_one% AND [TOTPOP1] < %value_two%)
 STYLE
COLOR 255 108 118
OUTLINECOLOR 255 255 255
 END
   END
   CLASS
      EXPRESSION ([TOTPOP1] >= %value_two% AND [TOTPOP1] < %value_three%)
 STYLE
COLOR 254 189 75
OUTLINECOLOR 255 255 255
 END
   END
   CLASS
 EXPRESSION ([TOTPOP1] >= %value_three% AND [TOTPOP1] < %value_four%)
 STYLE
COLOR 254 247 46
OUTLINECOLOR 255 255 255
 END
   END
   CLASS
 EXPRESSION ([TOTPOP1] >= %value_four% AND [TOTPOP1] < %value_five%)
 STYLE
COLOR 39 251 114
OUTLINECOLOR 255 255 255
 END
   END
   CLASS
 EXPRESSION ([TOTPOP1] >= %value_five% AND [TOTPOP1] <= %value_six%)
 STYLE
COLOR 108 111 205
OUTLINECOLOR 255 255 255
 END
   END
END
--
Regards,
Prabu Raja
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20111115/c2470466/attachment.htm>