> 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 &#39;pug2_iffi&#39;.
msOGRFileOpen(): OGR error. ExecuteSQL(SELECT * FROM pug_iffi c LEFT JOIN &#39;data/puglia/jointab.dbf&#39;.jointab b ON c.IDFRANA = b.IDFRANA) failed.
Unable to open secondary datasource
`data/puglia/jointab.dbf&#39; required by JOIN.
</ServiceException>
</ServiceExceptionReport>



Why ? Is the problem in the relative path ?

Frank Warmerdam, what about this ?

Thanks !

********************************************************************************************
graphic

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

********************************************************************************************
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

Reply via email to