<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi List and Steve<br>
<br>
A while ago I send this message to the list and Steve but I didn't get
an answer.<br>
is there nobody who uses the join functionality of MapServer <br>
It is for me very important because I'm customizing Pmapper/MapServer
for the local Dutch government<br>
so I hope somebody can and will help me.<br>
<br>
Dennis-Jan<br>
<br>
-------- Original Message --------
<table class="moz-email-headers-table" border="0" cellpadding="0"
cellspacing="0">
<tbody>
<tr>
<th align="right" nowrap="nowrap" valign="baseline">Subject: </th>
<td>Re: [UMN_MAPSERVER-USERS] Problems with join</td>
</tr>
<tr>
<th align="right" nowrap="nowrap" valign="baseline">Date: </th>
<td>Wed, 08 Feb 2006 11:29:24 +0100</td>
</tr>
<tr>
<th align="right" nowrap="nowrap" valign="baseline">From: </th>
<td>DJ Broerse <a class="moz-txt-link-rfc2396E" href="mailto:dennisjan@ibuildings.nl"><dennisjan@ibuildings.nl></a></td>
</tr>
<tr>
<th align="right" nowrap="nowrap" valign="baseline">To: </th>
<td>Steve Lime <a class="moz-txt-link-rfc2396E" href="mailto:steve.lime@dnr.state.mn.us"><steve.lime@dnr.state.mn.us></a>,
<a class="moz-txt-link-abbreviated" href="mailto:mapserver-users@lists.umn.edu">mapserver-users@lists.umn.edu</a></td>
</tr>
<tr>
<th align="right" nowrap="nowrap" valign="baseline">References: </th>
<td><a class="moz-txt-link-rfc2396E" href="mailto:s3e128f6.034@co5.dnr.state.mn.us"><s3e128f6.034@co5.dnr.state.mn.us></a></td>
</tr>
</tbody>
</table>
<br>
<br>
<pre>Hey Steve
I have two dfb files: gbkn-philippine and eigenaren
The reference is gbkn-philippine.willekeur and eigenaren.aa_linkid
What I want is if I query the the layer then I like to see the data of
eigenaren.dbf .
I can't figure out what is wrong.
Maybe I have to use CONNECTION or CONNECTIONTYPE but I don't know what.
TEMPLATE isn't necessary because I use a one-to-one relation I think.
I really hope you can help me
Dennis-Jan
LAYER
NAME "gbkn-philippine"
TYPE line
STATUS ON
DATA "join/gbkn-philippine"
MAXSCALE 25100
METADATA
"DESCRIPTION" "gbkn-philippine"
END # Metadata
JOIN
NAME "join1"
TABLE "gisdata/join/eigenaren.dbf"
FROM "WILLEKEUR"
TO "AA_LINKID"
TYPE ONE-TO-ONE
END
CLASS
Name "gbkn-philippine"
COLOR 249 49 249
TEMPLATE queryzichtbaar
SYMBOL "vet"
SIZE 2
END # Class
END # Layer
Steve Lime wrote:
> How are you referencing the attributes in the joined file? I believe the syntax is [joinname_attrname] in the template. Can you share the mapfile snippet and the template?
>
> Steve
>
>
--
DJ Broerse <a class="moz-txt-link-abbreviated" href="mailto:dennisjan@ibuildings.nl">dennisjan@ibuildings.nl</a>
Direct: 0118 42 95 68 Mobiel: 06 48 01 03 08
Skype: <a class="moz-txt-link-freetext" href="callto://dennisjan-ibuildings">callto://dennisjan-ibuildings</a>
Ibuildings.nl BV - Information technology
<a class="moz-txt-link-freetext" href="http://www.ibuildings.nl">http://www.ibuildings.nl</a> - 0118 42 95 50
</pre>
<br>
<div class="moz-signature">-- <br>
DJ Broerse <a class="moz-txt-link-abbreviated" href="mailto:dennisjan@ibuildings.nl">dennisjan@ibuildings.nl</a> <br>
Direct: 0118 42 95 68 Mobiel: 06 48 01 03 08 <br>
Skype: <a class="moz-txt-link-freetext" href="callto://dennisjan-ibuildings">callto://dennisjan-ibuildings</a> <br>
Ibuildings.nl BV - Information technology <br>
<a class="moz-txt-link-freetext" href="http://www.ibuildings.nl">http://www.ibuildings.nl</a> - 0118 42 95 50 </div>
</body>
</html>