bugs : msDBFGetItemIndex(): DBASE file error. Item not found

[Fabio D'Ovidio]

> It should however be possible to do what you want using OGR. Please 
> refer to this document for a howto:
> 
> http://mapserver.gis.umn.edu/docs/howto/ogr_howto


OK ! I have done this :

LAYER
  NAME "pug2_iffi"
  TYPE POINT
  STATUS ON
  TEMPLATE  "query.html"
  TOLERANCEUNITS  PIXELS
  TOLERANCE 1000
  CLASS
    NAME "Pug2_iffi"
    # TEMPLATE
    STYLE
    SYMBOL  "circlefd"
    SIZE 7
    COLOR  127 255 0  
    OUTLINECOLOR 0 0 0
   END
  END
  PROJECTION
		#Lat/Lon
		"init=EPSG:32633"
	END
  
  CONNECTIONTYPE OGR
  CONNECTION "puglia/pug_iffi.shp"

  
 # Tematizzazione
 DATA "SELECT * FROM pug_iffi c LEFT JOIN 'data/puglia/jointab.dbf'.jointab b ON 
c.IDFRANA = b.IDFRANA"
 
 

  END


And this is the error from Server :

<?xml version='1.0' encoding="ISO-8859-1" standalone="no" ?>
<!DOCTYPE ServiceExceptionReport SYSTEM 
"http://schemas.opengeospatial.net/wms/1.1.1/exception_1_1_1.dtd">
<ServiceExceptionReport version="1.1.1">
<ServiceException>
msDrawMap(): Image handling error. Failed to draw layer named 'pug2_iffi'.
msOGRFileOpen(): OGR error. ExecuteSQL(SELECT * FROM pug_iffi c LEFT JOIN 
'data/puglia/jointab.dbf'.jointab b ON c.IDFRANA = b.IDFRANA) failed.
Unable to open secondary datasource
`data/puglia/jointab.dbf' required by JOIN.
</ServiceException>
</ServiceExceptionReport>



Why ? Is the problem in the relative path ? 

Frank Warmerdam, what about this ?

Thanks !

********************************************************************************************


 Ing. Fabio D'Ovidio
 WebGIS Staff
 Planetek Italia Srl
 via Massaua, 12 - 70123 Bari - Italy
 web : http ://www.planetek.it
 e-mail : dovidio at planetek.it

********************************************************************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20060929/7f1b8cd5/attachment.htm>
-------------- next part --------------
The following section of this message contains a file attachment
prepared for transmission using the Internet MIME message format.
If you are using Pegasus Mail, or any other MIME-compliant system,
you should be able to save it or view it from within your mailer.
If you cannot, please ask your system administrator for assistance.

   ---- File information -----------
     File:  planetek.gif
     Date:  28 Feb 2006, 16:15
     Size:  1899 bytes.
     Type:  Unknown
-------------- next part --------------
A non-text attachment was scrubbed...
Name: planetek.gif
Type: application/octet-stream
Size: 1899 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20060929/7f1b8cd5/attachment.obj>