<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
<span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); ">Hi all </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); ">I want to create a pie chart for some data. The problem that I'm facing is that i'm not getting any errors when I test the layer using shp2img; however, I just get a white image. This is my mapfile: </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); ">MAP </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> EXTENT -20037508 -20037508 20037508 20037508 </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> SIZE 400 400 </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> IMAGETYPE PNG </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); ">LAYER </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> NAME "Survey" </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> TYPE CHART </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> CONNECTIONTYPE OGR </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> CONNECTION "MSSQL:server=myserver;database=data;uid=me;pwd=key" </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> DATA "SELECT Option, COUNT(*) AS RESULT FROM Survey GROUP BY Option" </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> PROCESSING "CHART_TYPE=pie" </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> PROCESSING "CHART_SIZE=30" </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> STATUS ON </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> CLASSITEM 'Option' </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> CLASS </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> EXPRESSION '1' </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> NAME "one" </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> STYLE </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> SIZE [RESULT] </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> COLOR 255 244 237 </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> END </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> END </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> CLASS </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> EXPRESSION '2' </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> NAME "two" </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> STYLE </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> SIZE [RESULT] </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> COLOR 255 217 191 </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> END </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> END </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> CLASS </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> EXPRESSION '3' </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> NAME "three" </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> STYLE </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> SIZE [RESULT] </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> COLOR 255 186 140 </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> END </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> END </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> CLASS </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> EXPRESSION '4' </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> NAME "Four" </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> STYLE </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> SIZE [RESULT] </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> COLOR 255 186 0 </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> END </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "> END </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); ">END </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); ">END </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); ">Any ideas of what could be missing in my mapfile? </span><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><br style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); "><span style="font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); ">Thanks</span> </div></body>
</html>