I am experimenting with joining database table from MS SQL to PostGIS layer. I have working setup of PEAR DB and MDB2. I am using currently MDB2
In mapfile there is "RESULT_JOIN" "mssql://user:[EMAIL PROTECTED]/testgis||[EMAIL PROTECTED]@[EMAIL PROTECTED],Level||gid||0" . Lines RESULT_FIELDS and RESULT_HEADERS are removed to see all attribute columns with original FIELD NAME from identify. Join is working, but when I try identify I get table with NO field name for joined fields. See: http://www.gista.sk/dl/bugs/pmapper/pmapper_join.png So I added line error_log($fldName . " : " . $fldValue); to function printFieldValues in incphp/query/query.php and in log there is: [30-Sep-2008 14:27:32] [30-Sep-2008 14:27:35] gid : 2319 [30-Sep-2008 14:27:35] por_c : 0 [30-Sep-2008 14:27:35] plocha : 21372.6 [30-Sep-2008 14:27:35] druh_zelene_string : nespracovaný záznam [30-Sep-2008 14:27:35] pokosene : f [30-Sep-2008 14:27:35] m_cast : 0 [30-Sep-2008 14:27:35] ulica : nespracovaný záznam [30-Sep-2008 14:27:35] druh_zelene : 0 [30-Sep-2008 14:27:35] vlastnik : nespracovaný záznam [30-Sep-2008 14:27:35] poznamka : nespracovaný záznam [30-Sep-2008 14:27:35] ID : 2319 [30-Sep-2008 14:27:35] Level : 0 Joined fields "ID" and "Level" are there ! So why I don't see them in result table ? Thanks -- Ivan ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ pmapper-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/pmapper-users
