Color by attributes - postgis connection

[Luis Treviño]

Steven:

You could try something like :

EXPRESSION ('[cabuty]' = 'CL')

on your mipe file

Regards,

Luis
2007/4/21, Steven De Vriendt <gisaalter at gmail.com>:
>
> I have some trouble colouring by an attribute value i/c with a postgis
> connection.
> I want to colour the column cabuty by 3 unique values.
> For now I'm trying to make a layer like this:
>
> LAYER
>   NAME "b_cabu_postgis"
>   CONNECTIONTYPE postgis
>   CONNECTION "host=localhost port=5432 dbname=globaalter
> user=postgres_db password=autodesk6.5"
>   DATA "the_geom from b_cabu"
>   STATUS ON
>   TYPE POLYGON
>   DUMP TRUE
>   TEMPLATE "ttt"
>    CLASSITEM "cabuty"
>    CLASS
>          EXPRESSION "CL"
>        STYLE OUTLINECOLOR 0 0 255
>        END
>          EXPRESSION "OO"
>        STYLE OUTLINECOLOR 255 0 255
>        END
>     END
>    METADATA
>    "wms_title" "gebouwen"
>    "gml_include_items" "all"
>     END
>     PROJECTION
>     "init=epsg:31300"
>     END
> END
>
> Only the expression 'OO' is coloured, the objects corresponding with
> 'CL' in the cabuty are not showing up...what am I doing wrong ?
>
> Thanks for helping out !
>
> Steven
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20070423/b4ca269d/attachment.htm>