Ciao Armin,
I'm trying to connect some table in MySQL to shape using JOIN as this example
LAYER
NAME lakespy2
TYPE POLYGON
STATUS ON
DATA lakespy2
CLASS
NAME 'Lakes & Rivers'
TEMPLATE "lakespy2.html"
COLOR 49 117 185
END
HEADER "lakespy2_header.html"
FOOTER "lakespy2_footer.html"
JOIN
CONNECTIONTYPE mysql
CONNECTION "hostname:username:password:database"
TABLE "lakespy2"
TO "id"
NAME "lakejoin"
FROM "ID"
END
END # lakes
How can I manage the HEADER and FOOTER option in pmapper?
do you think is it possible to do it?
Actually I need it because I have some information on MySQL to join
and I cannot migrate them because part of another db that is update
everyday.
The example above, if works correctly is perfect for me but I've no
idea how can I manage it in pmapper.
could you give me a suggestion?
luca
--
luca marletta
