Re: [pmapper-users] Oracle connection - advice needed

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

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:arm...@gm...]=20
> Sent: Thursday, November 23, 2006 11:36 PM
> To: Gambin Dejan
> Cc: pma...@li...
> Subject: Re: [pmapper-users] Oracle connection - advice needed
>=20
> Dejan
>=20
> it's not worth the time to try to have 1-n joins, the it's=20
> simply not working any more since 2 years or so, after a=20
> restructuring of the query part. It would need a bit of=20
> thinking how to handle it now.
>=20
> armin
>=20
> Gambin Dejan wrote:
> > OK I solved this one. I had to set:
> >=20
> > "RESULT_FIELDS" "ID", instead of "RESULT_FIELDS" "ID,DESC"
> >=20
> > thanks very much once again. Now I will try with one-to-many join=20
> > although Toni said it was not working correctly
> >=20
> > regards, dejan
> >=20
> >> -----Original Message-----
> >> From: pma...@li...
> >> [mailto:pma...@li...] On Behalf Of=20
> >> Gambin Dejan
> >> Sent: Thursday, November 23, 2006 2:44 PM
> >> To: pma...@li...
> >> Subject: Re: [pmapper-users] Oracle connection - advice needed
> >>
> >> Thanks Armin, it helped very much. Now I can get an=20
> attribute from my=20
> >> Oracle database and this is great. The only thing I still cannot=20
> >> figure out (maybe Toni can help :-) is that I get an=20
> "extra" column=20
> >> in my result table. For example, I set:
> >>
> >>   METADATA=20
> >>     "DESCRIPTION" "Poslovni prostori"
> >>     "RESULT_FIELDS" "ID,DESC"
> >>     "RESULT_HEADERS" "Id,Desc"
> >>     "RESULT_JOIN"=20
> >> "oci8://username:password@oracle||TABLE_NAME@OBJID@0@DESC||ID||1"
> >>   END  # Metadata
> >>
> >> ...I get the result table with correct header line (two=20
> fields), but=20
> >> the data record has three columns and the middle one is=20
> empty....it=20
> >> seems I have to play a little bit...
> >>
> >> regards, dejan
> >>
> >>> -----Original Message-----
> >>> From: Armin Burger [mailto:arm...@gm...]
> >>> Sent: Wednesday, November 22, 2006 2:44 PM
> >>> To: Gambin Dejan; pma...@li...
> >>> Subject: Re: [pmapper-users] Oracle connection - advice needed
> >>>
> >>> http://www.pmapper.net/wiki/doku.php?id=3Dfaq: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.=20
> I have a=20
> >>>> polygon shapefile holding my city buildings. Its dbf file has an=20
> >>>> 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=20
> database.=20
> >>>> 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"=20
> >>> 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
> >>>>
> >>>>
> >>=20
> ---------------------------------------------------------------------
> >> -
> >>>> --- Take Surveys. Earn Cash. Influence the Future of IT Join=20
> >>>> 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
> >>>>
> >>=20
> =
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DE
> >> V
> >>>> DEV _______________________________________________
> >>>> pmapper-users mailing list
> >>>> pma...@li...
> >>>> https://lists.sourceforge.net/lists/listinfo/pmapper-users
> >>> --
> >>> Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten=20
> zu sparen!=20
> >>> Ideal f=FCr Modem und ISDN: http://www.gmx.net/de/go/smartsurfer
> >>>
> >> --------------------------------------------------------------
> >> -----------
> >> Take Surveys. Earn Cash. Influence the Future of IT Join=20
> >> SourceForge.net's Techsay panel and you'll get the chance to share=20
> >> your opinions on IT & business topics through brief surveys - and=20
> >> earn cash=20
> >> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge
> >> &CID=3DDEVDEV
> >> _______________________________________________
> >> pmapper-users mailing list
> >> pma...@li...
> >> https://lists.sourceforge.net/lists/listinfo/pmapper-users
> >>
> >=20
> >=20
> ----------------------------------------------------------------------
> > --- Take Surveys. Earn Cash. Influence the Future of IT Join=20
> > SourceForge.net's Techsay panel and you'll get the chance to share=20
> > your opinions on IT & business topics through brief surveys=20
> - and earn=20
> > cash=20
> >=20
> =
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEV
> > DEV _______________________________________________
> > pmapper-users mailing list
> > pma...@li...
> > https://lists.sourceforge.net/lists/listinfo/pmapper-users
> >=20
>=20