<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><head>
<title></title>
<meta http-equiv="content-type" content="text/html;charset=utf-8"/>
<meta http-equiv="Content-Style-Type" content="text/css"/>
</head>
<body>
<div align="left">
<font face="Arial" color="#7f0000" size="2">
<span style=" font-size:10pt">
> It should however be possible to do what you want using OGR. Please </span></font>
</div>
<div align="left">
<font face="Arial" color="#7f0000" size="2">
<span style=" font-size:10pt">
> refer to this document for a howto:</span></font>
</div>
<div align="left">
<font face="Arial" color="#7f0000" size="2">
<span style=" font-size:10pt">
> </span></font>
</div>
<div align="left">
<font face="Arial" color="#7f0000" size="2">
<span style=" font-size:10pt">
> http://mapserver.gis.umn.edu/docs/howto/ogr_howto</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
OK ! I have done this :</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
LAYER</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
NAME "pug2_iffi"</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
TYPE POINT</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
STATUS ON</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
TEMPLATE "query.html"</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
TOLERANCEUNITS PIXELS</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
TOLERANCE 1000</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
CLASS</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
NAME "Pug2_iffi"</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
# TEMPLATE</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
STYLE</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
SYMBOL "circlefd"</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
SIZE 7</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
COLOR 127 255 0 </span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
OUTLINECOLOR 0 0 0</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
END</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
END</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
PROJECTION</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
#Lat/Lon</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
"init=EPSG:32633"</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
END</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
CONNECTIONTYPE OGR</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
CONNECTION "puglia/pug_iffi.shp"</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
# Tematizzazione</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
DATA "SELECT * FROM pug_iffi c LEFT JOIN 'data/puglia/jointab.dbf'.jointab b ON
c.IDFRANA = b.IDFRANA"</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
END</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
And this is the error from Server :</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<?xml version='1.0' encoding="ISO-8859-1" standalone="no" ?></span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<!DOCTYPE ServiceExceptionReport SYSTEM
"http://schemas.opengeospatial.net/wms/1.1.1/exception_1_1_1.dtd"></span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<ServiceExceptionReport version="1.1.1"></span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<ServiceException></span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
msDrawMap(): Image handling error. Failed to draw layer named 'pug2_iffi'.</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
msOGRFileOpen(): OGR error. ExecuteSQL(SELECT * FROM pug_iffi c LEFT JOIN
'data/puglia/jointab.dbf'.jointab b ON c.IDFRANA = b.IDFRANA) failed.</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
Unable to open secondary datasource</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
`data/puglia/jointab.dbf' required by JOIN.</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
</ServiceException></span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
</ServiceExceptionReport></span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
Why ? Is the problem in the relative path ? </span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
Frank Warmerdam, what about this ?</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
Thanks !</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
********************************************************************************************</span></font>
</div>
<div align="left"><img src="cid:4162695.1159525818.23965" width="89" height="36" border="0" alt="graphic"/>
</div>
<div align="left">
<font face="Comic Sans MS" size="2">
<span style=" font-size:10pt">
<b><br />
</b>
</span>
</font>
</div>
<div align="left">
<font face="Comic Sans MS" size="2">
<span style=" font-size:10pt">
<b> Ing. Fabio D'Ovidio</b></span></font>
</div>
<div align="left">
<font face="Comic Sans MS" size="2">
<span style=" font-size:10pt">
WebGIS Staff</span></font>
</div>
<div align="left">
<font face="Comic Sans MS" size="2">
<span style=" font-size:10pt">
Planetek Italia Srl</span></font>
</div>
<div align="left">
<font face="Comic Sans MS" size="2">
<span style=" font-size:10pt">
via Massaua, 12 - 70123 Bari - Italy</span></font>
</div>
<div align="left">
<font face="Comic Sans MS" size="2">
<span style=" font-size:10pt">
web : </span></font>
<font face="Comic Sans MS" color="#0000ff" size="2">
<span style=" font-size:10pt">
http ://www.planetek.it</span></font>
</div>
<div align="left">
<font face="Comic Sans MS" size="2">
<span style=" font-size:10pt">
e-mail : </span></font>
<font face="Comic Sans MS" color="#0000ff" size="2">
<span style=" font-size:10pt">
dovidio@planetek.it</span></font>
</div>
<div align="left">
<font face="Comic Sans MS" color="#0000ff" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
********************************************************************************************</span></font>
</div>
</body>
</html>