OGR join between shapefile and DBF

[Gambin Dejan]

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?

Thanks very much

regards, dejan