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