Well, it is working for me but let me explain: I have a polygon shape presenting buildings. There is a building ID in the dbf file. Oracle database has a table of locations inside the buildings. This table has also a building ID and it holds many locations attributes (area, volume, user, purpose, etc.). I have tried using one-to-many query in pmapper by joining tha shapefile with locations table. And it works..(by identify query). I get for example the "area" for each location inside the building. The problem is that pmapper incorrectly displays all the attributes for one building in one row instead of breaking the row for each location. But this can be solved I think.
So now I am confused about what you said. I really need to do this type of join and I will gladly contribute to make it working correctly. For now I am planning to solve the "one row" displaying problem and maybe support nquery (it is not working of course). Also, I didn't try with attribute query yet. regards, dejan > -----Original Message----- > From: Armin Burger [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 23, 2006 11:36 PM > To: Gambin Dejan > Cc: [email protected] > Subject: Re: [pmapper-users] Oracle connection - advice needed > > 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=DE > >> V > >>>> 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=DEV > > DEV _______________________________________________ > > 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
