If removing the superfluous ) doesn't solve your problem, you will needto elaborate on what "doesn't like it" means. Does it give an error message?
No, no error message... Query of a polygon does result in stalling the whole process.
I striped the map file, so that only one single layer appears.
Looks like this now:
LAYER
NAME co2_mdg_total
STATUS ON
CONNECTIONTYPE postgis
CONNECTION 'user=ss_admin password=450_data
dbname=geodataportal'
TYPE POLYGON
DATA "the_geom FROM
(
SELECT
c.the_geom,
c.name,
d.id_country AS uid
FROM
co2_mdg_total AS d
RIGHT JOIN
xxx
) AS foo USING UNIQUE uid USING
srid=4326"
CLASSITEM 'value'
CLASS
NAME ''
EXPRESSION ([value]=-10001)
TEMPLATE 'empty space'
END # CLASS
CLASS
NAME 'Units: Million Metric Tons of CO2'
EXPRESSION ([value]=-110003)
TEMPLATE 'units as title in legend'
END # CLASS
CLASS
NAME 'no data'
EXPRESSION ([value]=-9999)
COLOR 230 230 230
TEMPLATE 'dummy'
#OUTLINECOLOR 147 190 238
END # CLASS
CLASS NAME '0 to 1197596'
EXPRESSION ([value]<=1197596)
COLOR 255 255 178
TEMPLATE 'dummy'
#OUTLINECOLOR 147 190 238
LABEL
FONT arial
TYPE truetype
ANTIALIAS false
SIZE 7
COLOR 200 50 70
POSITION AUTO
PARTIALS FALSE
FORCE true
OFFSET 0 5
#OUTLINECOLOR 0 0 0
END
END # CLASS
.....
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
