[mapserver-users] join - my neverending story

[Mike Elstermann]

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.html