----- Original Message -----
Sent: Monday, September 25, 2006 7:54
PM
Subject: [UMN_MAPSERVER-USERS] Join dbf
with SQL Server table in GetFeatureInfo Request
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 *
FROM dbo.Query_IdFrana WHERE (cod_pro + id + subid =
IDFRANA)"
NAME "join"
FROM "IDFRANA"
END
PROJECTION
#Lat/Lon
"init=EPSG:32633"
END
END
********************************************************************************************
Ing. Fabio D'Ovidio
WebGIS Staff
Planetek Italia Srl
via Massaua, 12 - 70123 Bari -
Italy
web : http
://www.planetek.it
e-mail : [EMAIL PROTECTED]
********************************************************************************************
