[MS4W-Users] mapserver not displaying postgis layers

[Long Red]

Hi,

just a quick guess:

- status needs to be on
- if using short data query it is necessary to have a proper 
geometry_columns table
- transparency is deprecated

Regards,
R.L.


-----Original Message-----
From: Linnet Kwamboka <scientific1quash at gmail.com>
To: ms4w-users at lists.maptools.org
Date: Sat, 15 May 2010 08:02:27 -0700
Subject: [MS4W-Users] mapserver not displaying postgis layers

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

---- Content & Policy Scan by M+ Guardian ----
Millions of safe & clean messages delivered daily




---- Content & Policy Scan by M+ Guardian ----
Millions of safe & clean messages delivered daily