[mapserver-users] join - my neverending story
Mike Elstermann
mike.elstermann at halle.de
Tue Mar 5 05:07:38 PST 2002
thanks, baut how can I display the items from the joined dbf?
my problem:
1.) i have a shapfile called "test1" with an item "nr" in the dir: /mapserver/data
2.) i have also a dbf called "join1.dbf" in the dir: "c:\inetpub\wwwroot\mapserver\data\join1.dbf" also with an item "nr" and "wert1" and "test2"
3.) my map-file:
LAYER
NAME test
TYPE POLYGON
STATUS DEFAULT
DATA test1
LABELITEM NR
CLASS
SYMBOL 0
COLOR 255 0 0
OUTLINECOLOR 0 0 0
TEMPLATE "joinx.html"
JOIN
NAME jj
table "c:\inetpub\wwwroot\mapserver\data\join1.dbf"
from nr
to nr
type single
END # join
LABEL
COLOR 128 0 0
ANTIALIAS TRUE
SIZE tiny
END
END
HEADER "joinx_header.html"
FOOTER "joinx_footer.html"
END
4.) the templates
a) "joinx_header.html"
<font size+1><b>Layer: TEST</b></font><p>
<table cellpadding=5 cellspacing=2 border=0>
<tr bgcolor=#CCCCCC>
<th>NR</th><th>WERT1</th><th>TEXT2</th>
</tr>
b) "joinx_footer.html"
</table><p>
c) "joinx.html
<tr>
<td>[NR]</td>
<td>[WERT1]</td>
<td>[TEXT2]</td>
</tr>
but my query give me only this:
Layer: TEST
NR WERT1 TEXT2
5 [WERT1] [TEXT2]
:-( - where is the mistake? where are the value for "wert1" and "text2"??
greetings mikeE.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20020305/11716ad4/attachment.htm>
More information about the MapServer-users
mailing list