Re: [pmapper-users] Oracle connection - advice needed
Brought to you by:
arminburger
From: Armin B. <arm...@gm...> - 2006-11-23 22:36:05
|
Dejan it's not worth the time to try to have 1-n joins, the it's simply not=20 working any more since 2 years or so, after a restructuring of the query=20 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: >=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 altho= ugh Toni said it was not working correctly >=20 > regards, dejan >=20 >> -----Original Message----- >> From: pma...@li...=20 >> [mailto:pma...@li...] On=20 >> Behalf Of 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 attribute=20 >> from my Oracle database and this is great. The only thing I=20 >> still cannot figure out (maybe Toni can help :-) is that I=20 >> get an "extra" column 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=20 >> >> ...I get the result table with correct header line (two=20 >> fields), but the data record has three columns and the middle=20 >> one is empty....it 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. 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 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=20 >> mapserver. If not,=20 >>>> 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=20 >>>> SourceForge.net's Techsay panel and you'll get the chance=20 >> to share=20 >>>> your opinions on IT & business topics through brief surveys >>> - and earn >>>> cash >>>> >> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID= =3DDEV >>>> DEV _______________________________________________ >>>> pmapper-users mailing list >>>> pma...@li... >>>> https://lists.sourceforge.net/lists/listinfo/pmapper-users >>> -- >>> Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten 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=20 >> share your opinions on IT & business topics through brief=20 >> surveys - and 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 > -----------------------------------------------------------------------= -- > 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=3Djoin.php&p=3Dsourceforge&CID=3D= DEVDEV > _______________________________________________ > pmapper-users mailing list > pma...@li... > https://lists.sourceforge.net/lists/listinfo/pmapper-users >=20 |