Join dbf with SQL Server table in GetFeatureInfo Request

[Fabio D'Ovidio]

I've tried to do 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"
  DATA "SELECT IDFRANA from pug_iffi LEFT JOIN 'ODBC:sa/@dbo'.Query_IdFrana ON 
cod_pro + id + subid = IDFRANA"
  
  END


it doesn't work !

What about ?


On 25 Sep 2006 at 18:54, Fabio D'Ovidio wrote:

> 
> Hi. 
> 
> Is it possible to do something like this ? 
> 
> I'd like to JOIN feature_id in dbf layer with information stored in SQL Server table by an SQl 
> Statement. 
> 
> What about ? 
> 
> 
> 
>  LAYER 
>  NAME "pug_iffi" 
>  TYPE POINT 
>  STATUS ON 
>  TEMPLATE "query.html" 
>  DATA "puglia/pug_iffi.shp" 
>  TOLERANCEUNITS PIXELS 
>  TOLERANCE 1000 
>  CLASS 
>  NAME "Pug_iffi" 
>  # TEMPLATE 
>  STYLE 
>  SYMBOL "circlefd" 
>  SIZE 7 
>  COLOR 127 255 0 
>  OUTLINECOLOR 0 0 0 
>  END 
>  END 
>  
>  
>  JOIN 
>  CONNECTION 
>  "<OGRVRTDataSource> 
>  
>  <SrcDataSource>ODBC:sb/@dbo</SrcDataSource> 
>  <SrcLayer>Query_IdFrana</SrcLayer> 
>  
>  
>  </OGRVRTDataSource>" 
>  
>  CONNECTIONTYPE OGR 
>  
>  TABLE "Query_IdFrana" 
>  TO "SELECT * FROMdbo.Query_IdFrana WHERE(cod_pro + id + subid = IDFRANA)" 
>  NAME "join" 
>  FROM "IDFRANA" 
>  END 
> 
>  
>  
>  
>  PROJECTION 
> #Lat/Lon 
> "init=EPSG:32633" 
> END 
>  
>  
>  
> END 
> ******************************************************************************************** 
> graphic
> 
> 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 
> 
> ******************************************************************************************** 


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


 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

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