Hello Flavio,
As noted on the page you referred to, this JOIN only works for executed
queries...and I do not see a TEMPLATE in your layer. Are you aware that
this join only works for queries? (see the examples in that documentation)
-jeff
--
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/
On 10-11-29 10:43 AM, flaviocarmo wrote:
Hi,
I need to make a layer with a join between a shapefile and a non-spatial
table, stored on PostgreSQL. I've found this documentation
(http://mapserver.org/mapfile/join.html) but i could make it work, so, can u
guys help me looking at this configuration and tell me whats wrong?
LAYER
NAME "join_shape"
TYPE POLYGON
STATUS DEFAULT
DATA "join_shapefile.shp"
CLASS
NAME "Joined Shapes"
STYLE
OUTLINECOLOR 120 120 120
COLOR 0 30 255
END
END
TOLERANCE 20
JOIN
NAME "teste"
CONNECTION "dbname='testdb' host=GSERVER1 port=5432
user='test'
password='test' sslmode=disable"
CONNECTIONTYPE ogr
TABLE '"test"."nonspatial"'
FROM "code"
TO "code"
TYPE ONE-TO-ONE
END
END # layer
In this layer, i want to show only the geometrys in the shapefile
"join_shapefile.shp" that have a CODE column that is the same the CODE
column in the test.nonspatial table, stored on Postgre.
That is possible?
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users