<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:garamond,new york,times,serif;font-size:14pt">Thanks Forums, yesterday I already can appear graph from Mapserv vs 5.x<br><br>But, why just appear bar or pie without values?<br><br>Anyone can explain about the coding that should i write?<br><br>if i have mapfile with many layer and also many class, how to write it and display graph dynamic?<br><br>here the example:<br><br>i have 1 database with 4 tables (tA,tB,tC,tD), in one table has 4 fields <span style="font-weight: bold;">but </span>if<br>i want to display just 2 fields (region and total) from each table , how to write it down in Layer TYPE CHART?<br><br>if i wrote like this, it will display bar on the map all same, no short tall graph and all same pie, no part of it.<br><br><font size="2"><span style="font-family: arial,helvetica,sans-serif; font-weight: bold;"># tA</span><br style="font-family:
arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;"> LAYER</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;"> #NAME "tA"</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;"> STATUS DEFAULT</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;"> </span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;"> TYPE CHART</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;"> PROCESSING "CHART_TYPE=BAR"</span><br style="font-family: arial,helvetica,sans-serif;"><span
style="font-family: arial,helvetica,sans-serif;"> PROCESSING "CHART_SIZE=40 30" #specify size of the chart for pie or bar graphs</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;"> #PROCESSING "CHART_SIZE=20 10" #specify width n height for graphs</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;"> CONNECTIONTYPE POSTGIS</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;"> CONNECTION "user=xpassword=pass dbname=db host=localhost port=5432"</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;"> <span style="font-weight: bold;">DATA "the_geom FROM tA USING UNIQUE num" ## HOW
TO WRITE ?</span></span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;"> </span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;"> CLASS</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;"> NAME "Region 1"</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;"> TEMPLATE "./template_gender.html"</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;"> <span style="font-weight: bold;">EXPRESSION ([total]>=1000 and [total]<=2000) # is it rite?</span></span><br style="font-family:
arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;"> STYLE<br> <span style="font-weight: bold;">SIZE [region]</span><br style="font-family: arial,helvetica,sans-serif;"></span><span style="font-family: arial,helvetica,sans-serif;"> COLOR 255 255 0</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;"> OUTLINECOLOR 0 0 0</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;"> WIDTH 2</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">
ANTIALIAS TRUE</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;"> END#STYLE</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;"> END #CLASS</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;"> </span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;"> </span></font><font size="2"><span style="font-family: arial,helvetica,sans-serif;">CLASS</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> NAME "Region 2"</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> TEMPLATE "./template_gender.html"</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> EXPRESSION ([total]>=2001 and [total]<=3000) </span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> STYLE<br>
SIZE [region]<br style="font-family: arial,helvetica,sans-serif;">
</span><span style="font-family: arial,helvetica,sans-serif;"> COLOR 255 255 255</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> OUTLINECOLOR 0 0 0</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> WIDTH 2</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> ANTIALIAS TRUE</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> END#STYLE</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> END #CLASS</span></font><font size="2"><span style="font-family: arial,helvetica,sans-serif;"></span><span style="font-family: arial,helvetica,sans-serif;"></span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;"> </span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">END LAYER</span></font><br><br>############################################<br><br><font size="2"><span style="font-family: arial,helvetica,sans-serif; font-weight: bold;"># tB</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> LAYER</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> #NAME "tA"</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> STATUS DEFAULT</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> </span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> TYPE CHART</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> PROCESSING "CHART_TYPE=BAR"</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> PROCESSING "CHART_SIZE=40 30" #specify size of the chart for pie or bar graphs</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> #PROCESSING "CHART_SIZE=20 10" #specify width n height for graphs</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> CONNECTIONTYPE POSTGIS</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> CONNECTION "user=xpassword=pass dbname=db host=localhost port=5432"</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> <span style="font-weight: bold;">DATA "the_geom FROM tA USING UNIQUE num" ## HOW TO WRITE ?</span></span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> </span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> CLASS</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> NAME "Region 1"</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> TEMPLATE "./template_gender.html"</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> <span style="font-weight: bold;">EXPRESSION ([total]>=1000 and [total]<=2000) # is it rite?</span></span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> STYLE<br>
<span style="font-weight: bold;">SIZE [region]</span><br style="font-family: arial,helvetica,sans-serif;">
</span><span style="font-family: arial,helvetica,sans-serif;"> COLOR 255 255 0</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> OUTLINECOLOR 0 0 0</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> WIDTH 2</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> ANTIALIAS TRUE</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> END#STYLE</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> END #CLASS</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> </span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> </span></font><font size="2"><span style="font-family: arial,helvetica,sans-serif;">CLASS</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> NAME "Region 2"</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> TEMPLATE "./template_gender.html"</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> EXPRESSION ([total]>=2001 and [total]<=3000) </span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> STYLE<br>
SIZE [region]<br style="font-family: arial,helvetica,sans-serif;">
</span><span style="font-family: arial,helvetica,sans-serif;"> COLOR 255 255 255</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> OUTLINECOLOR 0 0 0</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> WIDTH 2</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> ANTIALIAS TRUE</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> END#STYLE</span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> END #CLASS</span></font><font size="2"><span style="font-family: arial,helvetica,sans-serif;"></span><span style="font-family: arial,helvetica,sans-serif;"></span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;"> </span><br style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: arial,helvetica,sans-serif;">END LAYER</span></font><br><span style="font-weight: bold;">:<br>:<br>until 2 layers more that describe 2 tables.<br><br></span>Thanks all,<br><br>-Theresia :)<span style="font-weight: bold;"><br></span></div><br>
</body></html>