Hey Armin Already a couple of days I am fighting with joins, at this moment with no luck at all. I hope you can help me.
I have a layer and this layer has to join another dbf-file. I know there are two possibilities to join. In your documentation you write that it isn't possible to join dbf-files because of the limitations of PEAR. Can you explain that? PEAR supports dbase and I can connect to the dbf-file. Through Pmapper I query the dbf with SELECT AB_GEMTE,AD_PERCNR FROM EIGENAREN WHERE AA_LINKID='PLP00C 02915' But the data array I get contains every record of the dbf-file regardless the select query. With a strange first record, probably meta data of the dbf file. METADATA "DESCRIPTION" "gbkn-philippine" "RESULT_JOIN" "dbase:////var/www/html/pmapper-dev/gisdata/join/eigenaren.dbf||EIGENAREN at [EMAIL PROTECTED] at AB_GEMTE,AD_PERCNR||WILLEKEUR||0" END # Metadata The other possibility is to join the dbf by MapServer. This gives me no results, no errors nothing. JOIN NAME "join1" TABLE "join/eigenaren.dbf" FROM "EIGENAREN.AA_LINKID" TO "GBKN-PHILIPPINE.WILLEKEUR" TYPE ONE-TO-ONE END I hope you can help me with this join. Dennis-Jan -- 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