<div><span class="268344607-12062008"><font face="Arial" size="2">Hi,</font></span></div>
<div><span class="268344607-12062008"></span>&nbsp;</div>
<div><span class="268344607-12062008"><font face="Arial" size="2">I&#39;m trying to get a 
one-to-many join in a Postgis db working. One-to-one is working&nbsp;fine, but when I 
use one-to-many and add a template to the join object, no joined records are 
returned. In fact, the join template seems to be ignored 
altogether.</font></span></div>
<div><span class="268344607-12062008"><font face="Arial" size="2">Does anyone have a 
working example? The documentation is limited to &quot;One-to-many joins: The more 
complex variant. If the join type is multiple (one-to-many) the template is 
replaced by the set of header, template file and footer specified in the 
mapfile.&quot;, and I&#39;m not exactly sure what this means. Do I need to specify where 
the &quot;many&quot; template(s) are inserted into the &quot;main&quot; 
template?</font></span></div>
<div><span class="268344607-12062008"></span>&nbsp;</div>
<div><span class="268344607-12062008"><font face="Arial" size="2">Here&#39;s the layer 
definition from my mapfile, and the templates:</font></span></div>
<div><span class="268344607-12062008"></span>&nbsp;</div>
<div><span class="268344607-12062008"><font face="Arial" size="2">LAYER&nbsp; <br>&nbsp; NAME 
Provincies<br>&nbsp; TYPE polygon<br>&nbsp; CONNECTIONTYPE postgis<br>&nbsp; CONNECTION 
&quot;host=localhost dbname=gisdb user=user password=pass&quot;<br>&nbsp; <br>&nbsp; DATA &quot;the_geom 
from nl97&quot;<br>&nbsp; STATUS on<br>&nbsp; <br>&nbsp; CLASS<br>&nbsp;&nbsp;&nbsp; COLOR 0 128 128<br>&nbsp;&nbsp;&nbsp; 
OUTLINECOLOR 0 64 64<br>&nbsp; END<br>&nbsp; <br>&nbsp; METADATA<br>&nbsp;&nbsp;&nbsp; &quot;wms_title&quot; 
&quot;Provincies&quot;<br>&nbsp;&nbsp;&nbsp; &quot;wms_srs&quot; &quot;EPSG:28992&quot;<br>&nbsp; END<br>&nbsp; <br>&nbsp; JOIN<br>&nbsp;&nbsp;&nbsp; NAME 
&quot;test&quot;<br>&nbsp;&nbsp;&nbsp; CONNECTION &quot;host=localhost dbname=gisdb user=user 
password=pass&quot;<br>&nbsp;&nbsp;&nbsp; CONNECTIONTYPE ogr<br>&nbsp;&nbsp;&nbsp; TABLE &quot;lookup&quot;<br>&nbsp;&nbsp;&nbsp; FROM 
&quot;provnr&quot;<br>&nbsp;&nbsp;&nbsp; TO &quot;provnr&quot;<br>&nbsp;&nbsp;&nbsp; TYPE one-to-many<br>&nbsp;&nbsp;&nbsp; TEMPLATE 
join.html<br>&nbsp; END<br>&nbsp; <br>&nbsp; HEADER header.html<br>&nbsp; FOOTER footer.html<br>&nbsp; 
TEMPLATE provincies.html<br>&nbsp; <br>END</font></span></div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div><span class="268344607-12062008"><font face="Arial" size="2">provincies.html:</font></span></div>
<div><span class="268344607-12062008"><font face="Arial" size="2">&lt;tr&gt;<br>&lt;td&gt;Naam: 
[provincie]&lt;/td&gt;<br>&lt;td&gt;Inwoners: 
[inwoners]&lt;/td&gt;<br>&lt;td&gt;Inkomen: 
[inkomen]&lt;/td&gt;<br>&lt;td&gt;Provcode: 
[provnr]&lt;/td&gt;<br>&lt;/tr&gt;</font></span></div>
<div><span class="268344607-12062008"></span>&nbsp;</div>
<div><span class="268344607-12062008"><font face="Arial" size="2">join.html:</font></span></div>
<div><span class="268344607-12062008"><font face="Arial" size="2">&lt;!-- Join 
starts&nbsp;here --&gt;</font></span></div>
<div><span class="268344607-12062008"><font face="Arial" size="2">&lt;tr&gt;&lt;td&gt;Joined field: 
[joined]&lt;/td&gt;&lt;/tr&gt;</font></span></div>
<div><span class="268344607-12062008">
<div><span class="268344607-12062008"><font face="Arial" size="2">&lt;!-- Join&nbsp;ends 
here&nbsp;--&gt;</font></span></div></span></div>