<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial,helvetica,sans-serif;font-size:10pt;color:#000000;">Hello Mapserver experts,<br><br>I have question in my mind, How to display Labels from 1 table in my database (Postgre + Postgis)?<br>in this table there are fields of : name_region, values_1, values_2, How to appear them? Could Mapserver make it? <br>I ask this question, because I want to show the difference values_1 between values_2 in my Bar Chart :)<br><br>if i do this (code in the bottom) then just appear <span style="font-weight: bold;">values_2</span> in the map :) ?<br><br>LAYER<br>STATUS DEFAULT<br> TYPE ANNOTATION<br> CONNECTIONTYPE POSTGIS<br> CONNECTION "user=x password=x dbname=mydb host=host port=5432"<br> DATA "the_geom FROM tb_region USING UNIQUE code_region"<br> <br>
LABELITEM "name_region"<br> CLASS<br> LABEL<br> COLOR 0 0 0<br> TYPE Truetype<br> FONT Arial<br> SIZE 11<br> MINSIZE 8<br> ANGLE Auto<br> POSITION UC<br> ANTIALIAS True<br> END # LABEL<br> END #CLASS<br> <br> LABELITEM "values_1"<br> CLASS<br> LABEL<br> COLOR 255 255 255<br> TYPE Truetype<br> FONT
Arial<br> SIZE 9<br> MINSIZE 8<br> ANGLE Auto<br> POSITION UC<br> ANTIALIAS True<br> END # LABEL<br> END #CLASS<br> <br>LABELITEM "values_2"<br> CLASS<br> LABEL<br> COLOR 255 255 255<br> TYPE Truetype<br> FONT Arial<br> SIZE 9<br> MINSIZE 8<br> ANGLE Auto<br> POSITION UC<br> ANTIALIAS True<br> END #
LABEL<br> END #CLASS<br>END #LAYER<br><br><div>Thanks really appreciate yours,<br><br>-Theresia :)<br></div>
</div><br>
</body></html>