OK I solved this one. I had to set: "RESULT_FIELDS" "ID", instead of "RESULT_FIELDS" "ID,DESC"
thanks very much once again. Now I will try with one-to-many join although Toni said it was not working correctly regards, dejan > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On > Behalf Of Gambin Dejan > Sent: Thursday, November 23, 2006 2:44 PM > To: [email protected] > Subject: Re: [pmapper-users] Oracle connection - advice needed > > Thanks Armin, it helped very much. Now I can get an attribute > from my Oracle database and this is great. The only thing I > still cannot figure out (maybe Toni can help :-) is that I > get an "extra" column in my result table. For example, I set: > > METADATA > "DESCRIPTION" "Poslovni prostori" > "RESULT_FIELDS" "ID,DESC" > "RESULT_HEADERS" "Id,Desc" > "RESULT_JOIN" > "oci8://username:[EMAIL PROTECTED]||[EMAIL PROTECTED]@[EMAIL > PROTECTED]||ID||1" > END # Metadata > > ...I get the result table with correct header line (two > fields), but the data record has three columns and the middle > one is empty....it seems I have to play a little bit... > > regards, dejan > > > -----Original Message----- > > From: Armin Burger [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, November 22, 2006 2:44 PM > > To: Gambin Dejan; [email protected] > > Subject: Re: [pmapper-users] Oracle connection - advice needed > > > > http://www.pmapper.net/wiki/doku.php?id=faq:configuration#join > s_to_external_database_tables > > > > > > > > > Hi, > > > > > > I have already asked a similar question but I really need > > an advice on > > > how to best implement connection from pmapper to Oracle. I have a > > > polygon shapefile holding my city buildings. Its dbf file has an > > > column with an building ID but the rest of attribute data > > that I need > > > to display in a query result table is held in Oracle 9i database. > > > These data are very dynamic so I have to dynamically > > connect to Oracle > > > and get the data when I click on a building with "Identify" > > or through > > > the attribute search. > > > > > > I don't know if anything is possible through the > mapserver. If not, > > > what is the way to go to support it in p.mapper? > > > > > > I would appreciate any suggestion. Thanks very much. > > > > > > regards, dejan > > > > > > > > > ---------------------------------------------------------------------- > > > --- Take Surveys. Earn Cash. Influence the Future of IT Join > > > SourceForge.net's Techsay panel and you'll get the chance > to share > > > your opinions on IT & business topics through brief surveys > > - and earn > > > cash > > > > > > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEV > > > DEV _______________________________________________ > > > pmapper-users mailing list > > > [email protected] > > > https://lists.sourceforge.net/lists/listinfo/pmapper-users > > > > -- > > Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! > > Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer > > > > -------------------------------------------------------------- > ----------- > Take Surveys. Earn Cash. Influence the Future of IT Join > SourceForge.net's Techsay panel and you'll get the chance to > share your opinions on IT & business topics through brief > surveys - and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge > &CID=DEVDEV > _______________________________________________ > pmapper-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/pmapper-users > ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ pmapper-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/pmapper-users
