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

[IMD Listuser]

Steve,

Thanks,

That worked for me 


Charlie Van Dusen
charlie at im-design.net

-----Original Message-----
From: Steven Monai [mailto:stevem at spatialmapping.com] 
Sent: Monday, July 19, 2004 1:57 PM
To: IMD Listuser; "Ednardo Ferreira"
Cc: mapserver-users at lists.gis.umn.edu
Subject: [SPAM] - RE: [Mapserver-users] mapserver doesnt show
anything... - Email found in subject

Ednardo and Charlie:

Here's a thread in the user list archive that may or may not shed some
light on your problem:

http://mapserver.gis.umn.edu/data2/wilma/mapserver-users/0306/msg00420.h
tml

Basically, try changing the "FROM" keyword to "from" in your DATA
string, and see if that works. It seems that older versions of MapServer
expected the "from" keyword to be all lower-case.

Hope this helps,
-SM
--
============================================
Steven Monai
Database & Application Developer
Spatial Mapping Ltd.
484 2nd Avenue
Prince George, BC, Canada
V2L 2Z7

http://www.spatialmapping.com
mailto:stevem at spatialmapping.com
phone: 250 564 1928
fax: 250 564 0751
============================================



> Subject: RE: [Mapserver-users] mapserver doesnt show anything...
> Date: Mon, 19 Jul 2004 11:58:22 -0400
> From: "IMD Listuser" <imd_listuser at comcast.net>
> To: "Ednardo Ferreira" <ednardof at yahoo.com>,
>         <mapserver-users at lists.gis.umn.edu>
>
> 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
>