I am able to draw and create a WMS mapfile for POLYGON and LINE but not for a POINT, I am not sure what maybe the issue, can you assist
LAYER
NAME Country
TYPE POINT
EXTENT -25 -35 51 37
CONNECTIONTYPE POSTGIS
CONNECTION 'host=localhost dbname=xxx user=xxxx password=xxx port=5432'
DATA "geom from (SELECT geom, gid FROM education WHERE country = 'xxxx' AND electricity = 'Yes' AND water = 'Yes') as subquery USING unique gid USING srid=4326"
METADATA
'wms_title' 'Country'
'wms_server_version' '1.1.0'
'gml_include_items' 'all'
'wms_include_items' 'all'
END
STATUS OFF
TRANSPARENCY 100
PROJECTION
'init=epsg:4326'
END
CLASS
NAME 'Country'
STYLE
SYMBOL "circle"
SIZE 16
COLOR 255 0 0
OUTLINECOLOR 0 0 0
END
END
END
Please assist...