<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-7">
<META content="MSHTML 6.00.6000.16414" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi!</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have two layers defined as
follows...</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>var mslayer1 = new OpenLayers.Layer.WMS( "SHAPEFILE
LAYER", <BR> "<A
href="http://83.212.51.160/cgi-bin/mapserv.exe?map=/ms4w/apps/emmanuel/htdocs/grdata_nomoi_wgs84.map">http://83.212.51.160/cgi-bin/mapserv.exe?map=/ms4w/apps/emmanuel/htdocs/grdata_nomoi_wgs84.map</A>",
{'layers': 'NOMOI' , 'format':'image/png'}); <BR>var mslayer2 = new
OpenLayers.Layer.WMS( "POSTGIS LAYER", <BR> "<A
href="http://83.212.51.160/cgi-bin/mapserv.exe?map=/ms4w/apps/emmanuel/htdocs/grdata_nomoi_wgs84.map">http://83.212.51.160/cgi-bin/mapserv.exe?map=/ms4w/apps/emmanuel/htdocs/grdata_nomoi_wgs84.map</A>",
{'layers': 'MATHITES' , 'format':'image/png'}); </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>and the following map file:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>MAP<BR>
IMAGETYPE png<BR>
EXTENT 19.341085 34.809638
29.577942 41.757412<BR>
SIZE 500
500<BR> SHAPEPATH
"c:/emmanuel/grdata"<BR> IMAGECOLOR 255 255
255<BR> UNITS DD</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>PROJECTION<BR>
"init=epsg:4326"<BR> END</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>SYMBOL<BR> NAME
"Circle"<BR> FILLED true<BR> TYPE
ellipse<BR> POINTS 1 1 END<BR>END</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV><FONT face=Arial size=2>
<DIV><BR> # LAYER SHAPEFILE ---------<BR>
LAYER<BR> NAME
NOMOI<BR> DATA
NOMOI_wgs84<BR> STATUS
OFF<BR> TYPE
POLYGON</DIV>
<DIV> </DIV>
<DIV> CLASS<BR>
NAME "The Greek
Prefectures"<BR>
STYLE<BR>
COLOR 200 200
200<BR> OUTLINECOLOR 32 32
32<BR> END<BR> END<BR> END
# <BR> </DIV>
<DIV>END # </DIV>
<DIV> </DIV>
<DIV><BR># Layer POSTGIS -----------</DIV>
<DIV> </DIV>
<DIV> LAYER # Mathites in PostGIS<BR>
NAME MATHITES<BR>
STATUS ON<BR> TYPE POINT<BR> CONNECTIONTYPE
POSTGIS<BR> CONNECTION "dbname=postgis
host=localhost<BR>
user=postgres password=postgres port=5432"<BR> DATA "the_geom from
(select the_geom from mathites_wgs84 where id <10)" </DIV>
<DIV> </DIV>
<DIV> CLASS<BR>
NAME
"Mathites"<BR> STYLE
<BR>
SYMBOL "Circle"<BR>
SIZE 3<BR>
COLOR 0 0
200<BR> END<BR>
END<BR> <BR>
PROJECTION<BR> "init=epsg:4326"</DIV>
<DIV> END<BR> <BR> END</DIV>
<DIV> </DIV>
<DIV>#End of Layer ---------------</DIV>
<DIV> </DIV>
<DIV>END</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>=================</DIV>
<DIV> </DIV>
<DIV>The SHAPEFILE layer works fine! Howver I cannot see the POSTGIS layer...
</DIV>
<DIV>I get an error message "declare mycursor binary cursor..."</DIV>
<DIV> </DIV>
<DIV>Any suggestion would be greatly appreciated !</DIV>
<DIV> </DIV>
<DIV>Emmanuel.</DIV>
<DIV> </DIV>
<DIV></FONT> </DIV></BODY></HTML>