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

Hi, Moreover you can use a long query to execute (or a view) in the LAYER->DATA parameter. And then specify only the geometric table (it requires all fields that are used for drawing : attributes binding, label, ...) in LAYER->METADATA->PM_RESULT_DATASUBSTITUTION. This one will be used for dra

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

hello Valerio, sorry for late reply, if you r still searching the answer and anybody searching for this answer. then here is solution. As you asked for to display joined records from external table in query identify div window, you need to query from DATA tag in map file. like this. LAYER NAM

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

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

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