[mapserver-users] SV: Use of a Colortable

[Peter Rose]

Hi Alex and David,

The data have fiscal values which I would like to display with differently sized coloured points depending on their value. I know how to do this with an EXPRESSION in the mapfile if the data is stored as an attribute in a shapefile but I can’t get it to work with my data in the MySQL database.
 
Here is my mapfile:
 
#####################################
# POI layer - points of interest
#
LAYER
     NAME "poi"
     STATUS default
     TYPE point
     LABELCACHE on
 
     CLASS
          NAME "Large fiscal"
          EXPRESSION ([fiscal] < 1)
          STYLE
               SYMBOL "Circle"
               SIZE 8
               COLOR 255 0 0
               BACKGROUNDCOLOR 255 0 0
          END
    END # class
 
     CLASS
          NAME "Small fiscal"
          EXPRESSION ([fiscal] > 1)
          STYLE
               SYMBOL "Circle"
               SIZE 8
               COLOR 0 255 0
               BACKGROUNDCOLOR 0 255 0
          END
    END # class
END # layer poi
#####################################
 
The database connection and all querying takes place in the php-file as I want to allow the users to change their search criteria. I therefore don’t want to include any database connection in the mapfile if possible.
 
Thanks in advance for your help. 
-- 
View this message in context: http://n2.nabble.com/Use-of-a-Colortable-tp2638330p2659279.html
Sent from the Mapserver - User mailing list archive at Nabble.com.