Re: [pmapper-users] join to postgresql table problem

2013-04-26 Thread Thomas RAFFIN
tle" "Ward" >END # Metadata > >CLASS > Name 'All' > COLOR 223 219 212 > OUTLINECOLOR 223 219 212 >END # Class > END # Layer > > > And i am using pmapper 4.2.0... > > and you can query as more field

Re: [pmapper-users] join to postgresql table problem

2013-04-26 Thread Suman
TLINECOLOR 223 219 212 END # Class END # Layer And i am using pmapper 4.2.0... and you can query as more field as you can specifying in DATA query. cheers, suman -- View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-users-join-to-p

Re: [pmapper-users] join to postgresql table problem

2012-03-15 Thread VT
Hi Chris, thanks for your reply but my problem is to display joined records from external table in query identify div window. I think this is a specific pmapper way to do that but when I uncomment the RESULT_JOIN tag in medatada I get the not-stopping wheel "RESULT_JOIN" "pgsql:// postgres:myp

Re: [pmapper-users] join to postgresql table problem

2012-03-15 Thread Chris forum
Hello Paolo, Here under a working example on how to connect to postgresql/postgis table (used with Cartoweb) : LAYER NAME "tree" TYPE POINT STATUS ON METADATA "id_attribute_string" "id_object" "query_returned_attributes" "id_object" END SYMBOLSCALE 1000 CONNECTIONTYPE postgi

[pmapper-users] join to postgresql table problem

2012-03-13 Thread VT
Hi, I'm trying to join a postgres table to shapefile layer (one-to-many) but I get no response from identify tool. Connection to postgres works correctly in a separate php file: $connstr = "dbname=cbam_db user=postgres password=mypass host=localhost port=5432"; $dbh = pg_connect($connstr)