[mapserver-users] RE: making POINT with SQL

[Rahkonen Jukka]

Hi,

First add DEBUG 5, it may generate some interesting information for you into ms_errorfile. Next, comment out maxscale to be sure it is not preventing the rendering. Change it to MAXSCALEDENOM later, maxscale is not to be used any more. Add PROJECTION into your LAYER for getting more control on what is happening. And tell us the exact request you were using. Very often a blank map without any errors means that Mapserver does not find data from the requested map window, and very often it is because of some misconfiguration or misunderstanding with projections.

-Jukka Rahkonen-

Juan Carlos Monestel wrote:

 
> Hi 
> it is not drawing and no error occurs




-----Original Message-----
From: Lime, Steve D (DNR) [mailto:steve.lime at state.mn.us]
Sent: Thu 4/7/2011 2:43 PM
To: Juan Carlos Monestel; mapserver-users at lists.osgeo.org
Subject: RE: making POINT with SQL 
 
What does "not working" mean? Steve

From: mapserver-users-bounces at lists.osgeo.org [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Juan Carlos Monestel
Sent: Thursday, April 07, 2011 12:04 PM
To: mapserver-users at lists.osgeo.org
Subject: [mapserver-users] making POINT with SQL


Hello
I'm trying to make an POINT in the map but it's not working

this is my Layer
layer
        name "ponto"
        connectiontype POSTGIS
        connection "dbname=xxxx user=xxxxx host=xxxxx port=xxxxx"
        data "geo_info from table"
        type point
        status on
        metadata
                tile_source "nocache"
        end
        maxscale 3000001
        class
                style
                        size 4
                        symbol "circulo"
                        color 0 0 0
                end
                style
                        size 1
                        symbol "circulo"
                        color 255 255 255
                end
        end
end


The SQL brings me an geo info ("0101000020E610000079E9263108DC42C08716D9CEF75338C0") that in text is = "POINT(-37.719 -24.328)"


Any Ideas ?