Hi all, i think i'll became crazy before solving this problem... I'm using pmapper 4.0 and mapserver 5.2.1 (installed with ms4w 2.3.1 stable version) on a windows server 2003 machine (32 bit os and service pack 2). I need to join a dbf table to a shape file. I already have read on the wiki, on the faq and everywhere how to do this, i follow exactly wath the tutorials says... but i haven't reach the result yet. This is wath i did:
-installed the DB and MDB2 pear package -created a MS Access .mdb file named "db_tabelle.mdb" -in the access file i linked the dbf file named "table2.dbf" to the mdb file -created the ODBC connection with DNS system name "tabelle" [witth "Microsoft Access Driver (*.mdb)"] -tested the pear connection with the following script (founded on the wiki at http://svn.pmapper.net/trac/wiki/FaqConfiguration ): <?php require_once('DB.php'); $dsn = "odbc://'':''/localh...@tabelle"; $dbh = DB::connect($dsn); if (DB::isError($dbh)) { die ($dbh->getDebugInfo()); } ?> the test was succesfully cause (as the wiki says) the resut page was blank -created the following string on the metadata tag of the shape in the mapfile: "RESULT_JOIN" "odbc://'':''/localh...@tabelle||tab...@id1@0...@sigla,SIGLA2,SITO,COMP_AMB,LINK||ID1||0" note that the field in the dbf file has the same name of the field in the shape file (ID1), and note that both of them are numeric fields and that is a 1:1 relation. I also have added the joined field name in the "RESULT_FIELDS" tag and in the "RESULT_HEADERS" tag. This is the entire metadata tag: METADATA "DESCRIPTION" "Monitoraggio puntuale" "RESULT_FIELDS" "SIGLA,ID1,SITO,COMP_AMB,NUM_RECETT" "RESULT_HEADERS" "Sigla,ID1,Sito,Componente_Ambientale,Numero_Recettore" "RESULT_HYPERLINK" "SIGLA" "RESULT_JOIN" "odbc://'':''/localh...@tabelle||tab...@id1@0...@sigla,SIGLA2,SITO,COMP_AMB,LINK||ID1||0" END # Metadata The final result is that the reuslt search windows doesn't appear and i can see a turning wheel on the left corner of the page. I don't konw wath i have to do more... Please help me Andrea ------------------------------------------------------------------------------ Beautiful is writing same markup. Internet Explorer 9 supports standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3. Spend less time writing and rewriting code and more time creating great experiences on the web. Be a part of the beta today. http://p.sf.net/sfu/beautyoftheweb _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
