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

[Gambin D. <Dej...@pu...>]

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: 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
>=20
> 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:
>=20
>   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
>=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...
>=20
> regards, dejan
>=20
> > -----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
> >=20
> > http://www.pmapper.net/wiki/doku.php?id=3Dfaq:configuration#join
> s_to_external_database_tables
> >=20
> >=20
> >=20
> > > Hi,
> > >=20
> > > 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.
> > >=20
> > > 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?
> > >=20
> > > I would appreciate any suggestion. Thanks very much.
> > >=20
> > > regards, dejan
> > >=20
> > >=20
> >=20
> ----------------------------------------------------------------------
> > > --- 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
> > >=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
> > --
> > 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
> >=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=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