Dejan it's not worth the time to try to have 1-n joins, the it's simply not working any more since 2 years or so, after a restructuring of the query part. It would need a bit of thinking how to handle it now.
armin Gambin Dejan wrote: > 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 > ------------------------------------------------------------------------- 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
