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 <[EMAIL PROTECTED]> > To: Steve Lime <[EMAIL PROTECTED]>, > [email protected] > References: <[EMAIL PROTECTED]> > > 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 > > > > > >
