[Mapserver-users] mapserver doesnt show anything...

[IMD Listuser]

I am seeing the same issue.

Have you resolved this?

Charlie 


Charlie Van Dusen
charlie at im-design.net

-----Original Message-----
From: mapserver-users-admin at lists.gis.umn.edu
[mailto:mapserver-users-admin at lists.gis.umn.edu] On Behalf Of Ednardo
Ferreira
Sent: Friday, July 16, 2004 9:41 AM
To: mapserver-users at lists.gis.umn.edu
Subject: [Mapserver-users] mapserver doesnt show anything...

Please, I'm having problems with mapserver and postgis. What is
happenning?

Thanks!

--------

My map is:

MAP
  IMAGETYPE PNG
  EXTENT -97.5 41.619778 -82.122902 49.38562 # Geographic coordinates
  SIZE 700 700
  SHAPEPATH "data"
  IMAGECOLOR 255 255 255

  # Start of LAYER DEFINITIONS
---------------------------------------------
  LAYER # States polygon layer begins here
    CONNECTIONTYPE postgis
    NAME "states"
    CONNECTION "host=branco dbname=teste user=postgres"
    DATA "the_geom FROM ednardo"
    STATUS DEFAULT
    TYPE POLYGON
    CLASS
    	COLOR 20 22 22
    END
 END

END # end of map file/object

and show this message:

msDrawMap(): Image handling error. Failed to draw layer named 'states'.
prep_DB(): Query error. Error executing POSTGIS DECLARE (the actual
query) statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT
asbinary(force_collection(force_2d()),'NDR'),OID::text
from WHERE && setSRID('BOX3D(-97.5
37.8194380657143,-82.122902 53.1859599342857)'::BOX3D,
find_srid('','','') )'

Postgresql reports the error as 'ERROR: parse error at or near "WHERE"
at character 104 '

More Help:

Error with POSTGIS data variable. You specified '<check your .map
file>'.
Standard ways of specifiying are :
(1) 'geometry_column from geometry_table'
(2) 'geometry_column from (<sub query>) as foo using unique <column
name> using SRID=<srid#>'

Make sure you put in the 'using unique <column name>'
and 'using SRID=#' clauses in.

For more help, please see
http://postgis.refractions.net/documentation.php

Mappostgis.c - version of Jan 23/2004.
msPOSTGISLayerParseData(): Query error. Error parsing POSTGIS data
variable. Must contain 'geometry_column from table_name' or 'geom from
(subselect) as foo'
(couldnt find ' from '). More help:

Error with POSTGIS data variable. You specified 'the_geom FROM ednardo'.
Standard ways of specifiying are :
(1) 'geometry_column from geometry_table'
(2) 'geometry_column from (<sub query>) as foo using unique <column
name> using SRID=<srid#>'

Make sure you put in the 'using unique <column name>'
and 'using SRID=#' clauses in.

For more help, please see
http://postgis.refractions.net/documentation.php 









		
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail
_______________________________________________
Mapserver-users mailing list
Mapserver-users at lists.gis.umn.edu
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users