joining shp and dbase files

[Emil Zegers]

Hello Alberto,

You cannot use the MapServer JOIN to classify and display attributes from
the join table (see bug
http://mapserver.gis.umn.edu/bugs/show_bug.cgi?id=674).

So the JOIN function for a LAYER has not disappeared but is not suited for
this purpose.

You could try using OGR JOIN however.

OGR SQL supports a limited form of one to one JOIN.

Somehting like:

CONNECTIONTYPE OGR
CONNECTION "data/popplace_pt"
DATA "SELECT columns FROM table LEFT JOIN some join statement"

Take a look at the JOIN examples at
http://www.remotesensing.org/gdal/ogr/ogr_sql.html

Regards,

Emil


-----Original Message-----
From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU]On
Behalf Of Alberto Gomez
Sent: donderdag 26 mei 2005 9:01
To: MAPSERVER-USERS at LISTS.UMN.EDU
Subject: [UMN_MAPSERVER-USERS] joining shp and dbase files

Hello list,

I'm using mapserver as cgi and I need to do a color classification by a
field in the dbase table, so that I can see any modification in this table
at real time in my map server.

I've tried to do a join between my shapefile and dbase table but the layer
disappeared. All that I've read is that Join function in mapfile is no
longer available. Is there any other way to do this? Can you post an
example?

Thanks in advance.