[MS4W-Users] mapserver not displaying postgis layers

[Linnet Kwamboka]

mapserver not displaying postgis layers



hey guys,
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

 LAYER
    NAME 'kenya_administrative'
    TYPE LINE
    CONNECTIONTYPE postgis
    CONNECTION "dbname='postgis-try' host=localhost port=5432
user='postgres' password='postgres'"
    DATA "the_geom FROM kenya_administrative"
    METADATA
      'wms_title' 'kenya_administrative'
    END
    STATUS OFF #when status in ON, its completely blank when off there is a
gray background
    TRANSPARENCY 100
    PROJECTION
    "init=epsg:31468"

    END
    CLASS
       NAME 'kenya_administrative'
       STYLE
         SYMBOL 0
         SIZE 2
         OUTLINECOLOR 150 123 90
         COLOR 0 0 0
       END
    END
  END

-- 
With regards,
Linnet Kwamboka
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/ms4w-users/attachments/20100515/96f80c68/attachment.htm