I doubt that this

pgsql://'':''postgres:postgres/....

will work as connection string to your database... remove '':'' and see
if it works. Otherwise use the normal debugging approach reading error
and debugging logs, XY layers use error logging for connection and query
execution.

armin

PS: if you're using Postgres anyway, why not install the PostGIS
extension and use a geometry instead of x/y numeric fields?


On 18/01/2009 07:58, Miguel Blanco wrote:
> Hello friends: 
> 
> I am trying to add a layer based on coordinates xy that are found in a 
> database postgresql, but me does not charge the points that have in the 
> table, in the viewfinder the image appears of "loading" and does not 
> stop never.  They can indicate me where this my error. 
> 
> #
> # Start of Layer Empresas
> #
> LAYER
>    NAME "Proyectos"
>    TYPE point
>    FEATURE
>      POINTS 0 0 END
>    END
> 
>    PROJECTION
>      "init=epsg:4326"
>    END
>    METADATA
>      "DESCRIPTION" "Proyectos"
>      "RESULT_FIELDS" "departamento, municipio"
>      "RESULT_HEADERS" "Departamento, Municipio"
> #     "RESULT_HYPERLINK" "municipio"
>      "XYLAYER_PROPERTIES" 
> "pgsql://'':''postgres:postgres/localh...@dbturismodb||ubicacion_proyecto||cordenadax,cordenaday,0"
>    END  # Metadata
> 
>   CLASS
>     STYLE
>       SYMBOL 3
>       SIZE 19
>       COLOR 0 0 0
>     END
>   END
> END  # Layer
> 


------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
pmapper-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users

Reply via email to