<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7226.0">
<TITLE>mapfile join</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">Hi,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">looking for some sample code showing a join use successfully. get a parsing error when using it under class. put it under layer, no parsing error but then XP tells me mapserv.exe has found a problem and is closing down. using mapserver 4.4.0 on XP and I get error on html page msDBFJoinConnect(): Unable to access file. (c:\ms4w\apps\mapserver_demos\ct\data\join.dbf). any clues. can i use a dbf file.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">I am trying to join to a shape file a seperate independent dbf file on a common field that is indexed in the shape file. the field is text type.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">I take it it can be accessed using the [join_<join_name>] template in a query template file for a one to many join where [join_<join_name>] gets replaced with the join header template and footer files and I assume that the template within the query template file is [<join_name>_<dbf_field_name>].</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Is it possible to refer to the qlayer as [join_<join_name>]? </FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">bye </FONT>
<BR><FONT SIZE=2 FACE="Arial">john</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">John Spotten</FONT>
<BR><FONT SIZE=2 FACE="Arial">Transport Modeller/GIS Developer</FONT>
<BR><FONT SIZE=2 FACE="Arial">Directorate of Transport, Roads and Stormwater</FONT>
<BR><FONT SIZE=2 FACE="Arial">City of Cape Town</FONT>
<BR><FONT SIZE=2 FACE="Arial">Tel : +27 21 4067325</FONT>
<BR><FONT SIZE=2 FACE="Arial">Fax : +27 21 4186989</FONT>
<BR><FONT SIZE=2 FACE="Arial">Cell : +27 846678901</FONT>
<BR><FONT SIZE=2 FACE="Arial">Email : john.spotten@capetown.gov.za</FONT>
<BR><FONT SIZE=2 FACE="Arial">Web : www.capetown.gov.za</FONT>
<BR><FONT FACE="Arial" SIZE=2 COLOR="#000000"> <<John Spotten.vcf>> </FONT>
</P>
</BODY>
</HTML>