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