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
