<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
I have moved the join but the join does nothing <br>
<br>
what can be wrong?<br>
<br>
LAYER<br>
NAME "gbkn-philippine"<br>
TYPE line<br>
STATUS ON<br>
DATA "join/gbkn-philippine"<br>
MAXSCALE 25100<br>
METADATA<br>
"DESCRIPTION" "gbkn-philippine"<br>
END # Metadata<br>
JOIN<br>
NAME "join1"<br>
TABLE "join/eigenaren.dbf"<br>
FROM "AA_LINKID"<br>
TO "WILLEKEUR"<br>
TYPE ONE-TO-ONE<br>
END<br>
CLASS<br>
Name "gbkn-philippine"<br>
COLOR 249 49 249<br>
TEMPLATE queryzichtbaar<br>
SYMBOL "vet"<br>
SIZE 2<br>
END # Class<br>
END # Layer<br>
<br>
Dennis-Jan<br>
<br>
<br>
Steve Lime wrote:
<blockquote cite="mids3df4a67.080@co5.dnr.state.mn.us" type="cite">
<pre wrap="">Your join is in the wrong spot in the layer definition and needs to move outside of the metadata block.
Steve
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">DJ Broerse <a class="moz-txt-link-rfc2396E"
href="mailto:dennisjan@IBUILDINGS.NL"><dennisjan@IBUILDINGS.NL></a> 01/31/06 7:30 AM >>>
</pre>
</blockquote>
</blockquote>
</blockquote>
<pre wrap=""><!---->Hi
Maybe someone can help me to make a join, so far I am not successful.
I have two dbf files which I want to join. One is a layer/shape and the
other is a dbf file.
The dbf of the shape has a column "willekeur" and the other has a column
"aa_linkid".
What I want is all the data from the dbf file (eigenaren.dbf) joined in
the shape dbf.
I have written this layer with the join but I get an error:
[MapServer Error]: loadHashTable(): Parsing error near (JOIN):(line
361)\n in /var/www/html/pmapper-dev/incphp/globals.php on line 76
Can someone help me?
Dennis-Jan
This is the layer:
LAYER
NAME "gbkn-philippine"
TYPE line
STATUS ON
DATA "join/gbkn-philippine"
MAXSCALE 25100
METADATA
"DESCRIPTION" "gbkn-philippine"
JOIN
NAME "join1"
TABLE "/var/www/html/pmapper-dev/gisdata/join/eigenaren.dbf"
FROM "AA_LINKID"
TO "WILLEKEUR"
# TYPE "ONE-TO-ONE"
END
END # Metadata
CLASS
Name "gbkn-philippine"
COLOR 249 49 249
TEMPLATE queryzichtbaar
SYMBOL "vet"
SIZE 2
END # Class
END # Layer
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
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>
<pre class="moz-signature" cols="72">--
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>
</body>
</html>