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 






Reply via email to