Problems with join

DJ Broerse dennisjan at IBUILDINGS.NL
Tue Jan 31 05:30:51 PST 2006


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

-- 
DJ Broerse	dennisjan at ibuildings.nl 
Direct: 0118 42 95 68 Mobiel: 06 48 01 03 08 
Skype: callto://dennisjan-ibuildings
Ibuildings.nl BV - Information technology 
http://www.ibuildings.nl - 0118 42 95 50 



More information about the MapServer-users mailing list