<DIV>
<DIV>Hi,</DIV>
<DIV> </DIV>
<DIV>I am not very advanced with MAPSEVER, but still...</DIV>
<DIV>Does anyone have EVER successfully used JOIN OBJECT? I want to join a DBF with a SHP (MULTIPLE JOIN)</DIV>
<DIV> </DIV>
<DIV>In Mapserver reference file (<A href="http://mapserver.gis.umn.edu/doc44/mapfile-reference.html#join">http://mapserver.gis.umn.edu/doc44/mapfile-reference.html#join</A>) it is written "Joins are defined within a query object." WHAT IT MEANS? the map file should look like:</DIV>
<DIV>LAYER</DIV>
<DIV>....<BR>QUERY</DIV>
<DIV> JOIN</DIV>
<DIV> etc</DIV>
<DIV>I tried like this but I receive the error :loadLayer(): Unknown identifier. Parsing error near (QUERY)</DIV>
<DIV>obvious the map file should look different</DIV>
<DIV> </DIV>
<DIV>I have the shape (COUNTY.SHP) file with the following fields (ITEMS): SHAPE, CODE</DIV>
<DIV>I have the DBF (CODE.DBF) file with the following fields (ITEMS): CODE, COUNTY, TOWN, YEAR</DIV>
<DIV>I wanted to join them (MULTIPLE JOIN=ONE TO MANY), so I used as Mapserver reference say:</DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV>LAYER</DIV>
<DIV>......</DIV>
<DIV><FONT size=2>HEADER 'templates/code_header.html'</FONT></DIV>
<DIV><FONT size=2>FOOTER 'templates/code_footer.html'</FONT></DIV>
<DIV><FONT size=2>TOLERANCE 3</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>CLASS</FONT></DIV>
<DIV><FONT size=2> COLOR 200 0 200</FONT></DIV>
<DIV><FONT size=2> SIZE 10</FONT></DIV>
<DIV><FONT size=2> SYMBOL "circule"</FONT></DIV>
<DIV><FONT size=2> TEMPLATE 'templates/code.html'</FONT></DIV>
<DIV><FONT size=2>END</DIV></FONT>
<DIV> </DIV>
<DIV>JOIN</DIV>
<DIV><FONT size=2> FROM CODE</FONT></DIV>
<DIV><FONT size=2> NAME CODE_JOIN </FONT></DIV>
<DIV><FONT size=2> TABLE "E:\mapserver\shp\CODE.DBF"</FONT></DIV>
<DIV><FONT size=2> TEMPLATE "templates\CODE.HTML"</FONT></DIV>
<DIV><FONT size=2> TO CODE</FONT></DIV>
<DIV><FONT size=2> TYPE multiple</FONT></DIV>
<DIV><FONT size=2>END</FONT></DIV>
<DIV> </DIV>
<DIV>I receive the following result:</DIV>
<DIV>
<TABLE width=270 border=1>
<TBODY>
<TR>
<TD width=8> </TD>
<TD width=43>CODE</TD>
<TD width=76>COUNTY</TD>
<TD width=58>TOWN</TD>
<TD width=51>YEAR</TD></TR>
<TR>
<TD>1</TD>
<TD>1026</TD>
<TD>[COUNTY]</TD>
<TD>[TOWN]</TD>
<TD>[YEAR]</TD></TR></TBODY></TABLE></DIV>
<DIV> </DIV>
<DIV><FONT size=2>If I comment the TEMPLATE from JOIN nothink happend, but if I comment the TEMPLATE from CLASS I get the error: msQueryByRect(): Search returned no results. No matching record(s) found.</FONT></DIV>
<DIV> </DIV>
<DIV>WHAT is happening? What and where I do wrong?</DIV>
<DIV>DOES ANY ONE HAVE A WORKING EXAMPLE? I MEAN SOME ONE WHO USED OR USE JOIN OBJECT</DIV>
<DIV> </DIV>
<DIV>There are any other ways to JOIN (ONE TO MANY) data?</DIV>
<DIV> </DIV>
<DIV>Thank you in advance</DIV>
<DIV> </DIV>
<DIV>William</DIV>
<DIV><FONT size=2> </DIV></FONT>
<DIV> </DIV></DIV><p>
<hr size=1>Yahoo! Mail<br>
Stay connected, organized, and protected. <a href="http://tour.mail.yahoo.com/mailtour.html">Take the tour</a>