<!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>1000s thanks, but i need also the
temlate-files.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>
<DIV><FONT face=Arial size=2>my old 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></STRONG> </DIV></FONT></DIV>
<DIV>---> mfg mikeE.
:-)<BR> <BR>---> mail: <A
href="mailto:mike@mikee.de">mike@mikee.de</A><BR>---> @web:
<A
href="http://www.mikee.de">http://www.mikee.de</A><BR>--->
@wap: <A href="http://www.mikee.de/wap">http://www.mikee.de/wap</A> (dinge, die
die welt nicht braucht!)<BR>---> icq:
129278959<BR>---> siehe auch:<BR>--->
<A
href="http://www.hallelinks.de">www.hallelinks.de</A><BR>--->
<A
href="http://www.rettet-die-berliner-bruecke.de">www.rettet-die-berliner-bruecke.de</A><BR>--->
<A
href="http://www.buergerforum-halle.de">www.buergerforum-halle.de</A><BR>--->
<A
href="http://www.ohnesocken.de">www.ohnesocken.de</A><BR>--->
<A
href="http://www.elstermanns.de">www.elstermanns.de</A><BR>--->
<A href="http://www.tonart-halle.de">www.tonart-halle.de</A></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT><FONT face=Arial
size=2></FONT><BR> </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=Rich@GreenwoodMap.com href="mailto:Rich@GreenwoodMap.com">Richard
Greenwood</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=mike.elstermann@halle.de
href="mailto:mike.elstermann@halle.de">Mike Elstermann</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A
title=mapserver-users@lists.gis.umn.edu
href="mailto:mapserver-users@lists.gis.umn.edu">mapserver-users@lists.gis.umn.edu</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, March 05, 2002 5:53
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [mapserver-users] problem
with join</DIV>
<DIV><FONT face=Arial size=2></FONT><FONT face=Arial
size=2></FONT><BR></DIV>You can create a join in your map file. Here's an
example:<BR><BR>Class<BR> Join<BR> from
PIDN<BR> name
jointest<BR> table
"\Tc\DATA\assessor.DBF"<BR> # TEMPLATE
join_region.shp_query.html # required only for one-to-many
joins<BR>
to<X-TAB> </X-TAB>Pidn<BR>
type single<BR> End # of Join Object<BR> SYMBOL
"Solid"<X-TAB> </X-TAB><X-TAB> </X-TAB><BR>
OUTLINECOLOR 0 0 0<BR>END # of Class<BR><BR>This is pretty well documented. Be
careful how much editing is done to the dbf - adding or deleting records will
break the join.<BR><BR>Also note that you can only use a join for queries, not
labeling. If you need to label features off the dbf you are out of luck. You
will need to create the join in ArcView or MapInfo, and save it out as a
single, static layer.<BR><BR>Rich<BR><BR><BR>At 11:54 AM 3/4/2002 +0100, you
wrote:<BR>
<BLOCKQUOTE class=cite cite="" type="cite"><FONT face=arial size=2>hi,
</FONT><BR> <BR><FONT face=arial size=2>my (little)
problem:</FONT><BR> <BR><FONT face=arial size=2>i have a shape and i
have ab big dbf-file.</FONT><BR><FONT face=arial size=2>the polys in the
shape have 1 (one!) item - the ID , all other dates are in the dbf
(landuse, name, number, ........)</FONT><BR><FONT face=arial size=2>i want
to join both files to shade the poly in different views (first landuse,
later name, ....)</FONT><BR><FONT face=arial size=2>my users should only
edit in the dbf-file!</FONT><BR> <BR><FONT face=arial size=2>and now my
problem: how must I join to shade different with datas from the joined
dbf???</FONT><BR><FONT face=arial size=2>who has an example for me
(map-file?)</FONT><BR> <BR><FONT face=arial size=2>great
thanks.</FONT><BR><FONT face=arial size=2>mikeE.:-)</BLOCKQUOTE><X-SIGSEP>
<P></X-SIGSEP><BR>Richard W. Greenwood, PLS<BR>Greenwood Mapping,
Inc.<BR>Rich@GreenwoodMap.com<BR>(307) 733-0203<BR><A
href="http://www.greenwoodmap.com/"
eudora="autourl">http://www.GreenwoodMap.com</A></FONT>
</P></BLOCKQUOTE></BODY></HTML>