Hii, all... Please help me to join a database postgresql in pmapper. i'm using pampper 4.2.0, mapserver 6.0.1, postgresql 8.3
i has tried in postgresql with sql syntax: SELECT province.the_geom as the_geom, province.province_id as p_id, town.town_id as t_id FROM province JOIN town ON province.province_id = town.province_id it's worked, but if i'm trying in file .map it's error "still loading". please look my file .map and correct this if you know: LAYER NAME "join" TYPE POINT STATUS DEFAULT CONNECTIONTYPE postgis CONNECTION "host=localhost port=5432 dbname=test user=postgres password=postgresql" DATA 'the_geom from (SELECT province.the_geom as the_geom, province.province_id as p_id, town.town_id as t_id FROM province JOIN town ON province.province_id = town.province_id) as subquery USING UNIQUE gid USING srid=-1' TEMPLATE void PROJECTION # WGS84 "+proj=longlat +ellps=WGS84 +datum=WGS84 +no_defs " END METADATA "DESCRIPTION" "" "RESULT_FIELDS" "" "RESULT_HEADERS" "" "LAYER_ENCODING" "UTF-8" "ows_title" "" END CLASS NAME "join" # TEMPLATE COLOR 151 1 222 OUTLINECOLOR 255 0 255 SYMBOL 'circle' SIZE 6 END END Please, help me... and sorry if my english is bad... ------------------------------------------------------------------------------ Virtualization & Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
