<br><br><div class="gmail_quote"><br><br clear="all">mapserver not displaying postgis layers<br><br><br><br>hey guys,<br>i have trouble displaying postgis layers on mapserver nothing at all seems to work, any idea how i can change this, coz when i load directly from  a shapefile, everything is ok, but not postgis, here is the code<br>


<br> LAYER<br>    NAME &#39;kenya_administrative&#39;<br>    TYPE LINE<br>    CONNECTIONTYPE postgis<br>    CONNECTION &quot;dbname=&#39;postgis-try&#39; host=localhost port=5432 user=&#39;postgres&#39; password=&#39;postgres&#39;&quot;<br>


    DATA &quot;the_geom FROM kenya_administrative&quot;<br>    METADATA<br>      &#39;wms_title&#39; &#39;kenya_administrative&#39;<br>    END<br>    STATUS OFF #when status in ON, its completely blank when off there is a gray background<br>


    TRANSPARENCY 100<br>    PROJECTION<br>    &quot;init=epsg:31468&quot;<br><br>    END<br>    CLASS<br>       NAME &#39;kenya_administrative&#39; <br>       STYLE<br>         SYMBOL 0 <br>         SIZE 2 <br>         OUTLINECOLOR 150 123 90<br>


         COLOR 0 0 0<br>       END<br>    END<br>  END<br><br>-- <br>With regards,<br><font color="#888888"> Linnet Kwamboka<br><br>
</font></div><br><br>