Gambin Dejan wrote:
Hi,
I have read Frank's post on this subject. I am interested if there is a
way to use relative paths in defining joins between shapefile and DBF.
In my case, I have many layers using this join and suddenly they stopped
working. Since now they worked in following way:
...
CONNECTIONTYPE OGR
CONNECTION "/var/www/demodata" //path to folder where the shapefile
resides
DATA "SELECT a.ID, b.NAME FROM a LEFT JOIN b ON a.ID=b.ID" //b is table
in b.dbf
...
But it stopped working after I changed the mapserver and p.mapper
version. Now the only way it works is the following:
...
CONNECTIONTYPE OGR
CONNECTION "/var/www/demodata/a.shp" //path to the shapefile
DATA "SELECT a.ID, b.NAME FROM a LEFT JOIN '/var/www/demodata/b.dbf'.b
ON a.ID=b.ID"
...
Why is that? Is there a way I don't have to enter all the full paths
here?
Dejan,
It is not obvious to me why the behavior changed, but it is presumably
a change in the OGR Shapefile driver, not MapServer. Perhaps you could
switch to private email and let me know what "ogrinfo /var/www/demodata"
reports. The key is whether the "b" layer representing the dbf shows up
in this list or not.
Best regards,
--
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up | Frank Warmerdam, [EMAIL PROTECTED]
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush | President OSGeo, http://osgeo.org
