On 12/16/2009 11:17 AM, Timbonicus Hansen wrote:
I'm using a PostGIS database as the DATA source for a mapfile layer and
rendering dynamic labels using MapServer expressions:
TEXT ([columnName])
I'd like the label to be uppercase, is there any way to transform the
column text using MapServer expressions, or to trick MapServer into
selecting the column with UPPER(columnName)? I'm fearful that this might
mean reworking how the whole process works and not using a simple
mapfile approach any more.
- Tim
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Yea, in your layer, use a DATA line like:
DATA "the_geom FROM (select gid, the_geom, upper(columnName) as
columnName from table) as subquery using unique gid using srid=3417"
-Andy
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
