Problems with join {Scanned}

[Siki Zoltan]

Hi,

I have used one-to-many join between dbf files.
I have used layer template outside class definitions, one template for all 
classes.
What is in your template you should refer to columns in the joint table as
joinname_columnname. AFAIK it is case sensitive I had to use lower case 
for the join name and upper case for the columnname. I think you should 
avoid "_" in the column and join name.

I hope this help.

Bye
Zoltan

On Mon, 20 Feb 2006, DJ Broerse wrote:

> Hi List and Steve
> 
> A while ago I send  this message to the list and Steve but I didn't get
> an answer.
> is there nobody who uses the join functionality of MapServer
> It is for me very important because I'm customizing Pmapper/MapServer for
> the local Dutch government
> so I hope somebody can and will help me.
> 
> Dennis-Jan
> 
> -------- Original Message --------
> Subject: Re: [UMN_MAPSERVER-USERS] Problems with join
> Date: Wed, 08 Feb 2006 11:29:24 +0100
> From: DJ Broerse <dennisjan at ibuildings.nl>
> To: Steve Lime <steve.lime at dnr.state.mn.us>,
> mapserver-users at lists.umn.edu
> References: <s3e128f6.034 at co5.dnr.state.mn.us>
> 
>  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
> >
> >   
> 
>