<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2600.0" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>
<DIV><FONT face=Arial size=2>thanks, baut how can I display the items from the
joined dbf?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>my problem:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>1.) i have a shapfile called "test1" with an item
"nr" in the dir: /mapserver/data</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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"</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>3.) my map-file:</FONT></DIV>
<DIV><FONT face=Arial size=2>LAYER<BR> NAME test<BR>
TYPE POLYGON<BR> STATUS DEFAULT<BR> DATA
test1<BR> LABELITEM NR<BR>
CLASS<BR> SYMBOL 0<BR> COLOR 255
0 0<BR> OUTLINECOLOR 0 0 0<BR>
TEMPLATE "joinx.html"<BR>
JOIN<BR> NAME
jj<BR> table
"c:\inetpub\wwwroot\mapserver\data\join1.dbf"<BR>
from nr<BR> to
nr<BR> type
single<BR> END # join<BR>
LABEL<BR> COLOR 128 0
0<BR> ANTIALIAS
TRUE<BR> SIZE
tiny<BR> END<BR> END<BR>
HEADER "joinx_header.html"<BR> FOOTER
"joinx_footer.html"</FONT></DIV>
<DIV><FONT face=Arial size=2>END<BR></FONT></DIV>
<DIV><FONT face=Arial size=2>4.) the templates</FONT></DIV>
<DIV><FONT face=Arial size=2>a) "joinx_header.html"<BR></FONT><FONT face=Arial
size=2><font size+1><b>Layer:
TEST</b></font><p><BR><table cellpadding=5 cellspacing=2
border=0><BR><tr
bgcolor=#CCCCCC><BR><th>NR</th><th>WERT1</th><th>TEXT2</th><BR></tr></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>b) "joinx_footer.html"</FONT></DIV>
<DIV><FONT face=Arial size=2></table><p></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>c) "joinx.html</FONT></DIV>
<DIV><FONT face=Arial
size=2><tr><BR><td>[NR]</td><BR><td>[WERT1]</td><BR><td>[TEXT2]</td><BR></tr><BR></DIV>
<DIV>but my query give me only this:</DIV>
<DIV><STRONG>Layer: TEST</STRONG> </DIV>
<P>
<TABLE cellSpacing=2 cellPadding=5 border=0>
<TBODY>
<TR bgColor=#cccccc>
<TH>NR</TH>
<TH>WERT1</TH>
<TH>TEXT2</TH></TR>
<TR>
<TD>5</TD>
<TD>[WERT1]</TD>
<TD>[TEXT2]</TD></TR></TBODY></TABLE></P>
<DIV><STRONG>:-( - where is the mistake? where are the value for "wert1" and
"text2"??</STRONG></DIV>
<DIV><STRONG></STRONG> </DIV>
<DIV><STRONG>greetings mikeE.</STRONG></DIV>
<DIV><BR></FONT></FONT><FONT face=Arial
size=2></FONT> </DIV></DIV></BODY></HTML>