We do that kind of join with a lot of our data. Here's a code snippet
from a polygon layer in one of our maps:
LAYER #Service area poly layer starts here
NAME Service_areas
CONNECTIONTYPE ogr
CONNECTION "/path/to/shape/file/on/mapserver/cpws.shp"
DATA "SELECT * FROM cpws LEFT JOIN
Thank you Charles! Your example really works and I very quckly managed to
achieve what I intended.
BUT it is a different thing - you make a join during constracting the layer
and I suppose that it should affect how a layer looks like.
I was asking about the JOIN object of the mapfile, that accord
Dear Charles, dear list,
As I said, I used your piece of map-file code and made the connection. Now I
try the same but with another shapefile to another table in the same
database, and I receive a segmentation fault of the Apache!
Here follows the code from the map-file:
- this works just fine -