[UMN_MAPSERVER-USERS] Problems with join

[DJ Broerse]

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]>, mapserver-users@lists.umn.edu 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 > > -- DJ Broerse [EMAIL PROTECTED] 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 -- DJ Broerse [EMAIL PROTECTED] 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