[mapserver-users] Use of a Colortable

[Heiko Schröter]

Hello,,

we are mapping global satellite data with postgis.

Is it possible with mapserver to change the color of the symbol according to 
the value read in from postgis ?
Now the color is fixed within the mapfile reading only the geolocations i.e.

LAYER
  CONNECTION "user=bla password=blub dbname=foo host=fum"
  DATA "geocenter from table1"
      CLASS
          COLOR 50 150 150
          SYMBOL "circle"
          SIZE 5
      END
END

My (maybe/probably ill) idea is something like:
...
DATA "value and geocenter from table1"
...
COLOR on value using "/dir/my_colortable.dat"
SYMBOL "circle"
...

But it looks like that only one coloumn of the GIS Table could be read for a 
given LAYER.DATA  statement.

Thanks for any suggestion.

Regards
Heiko