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

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

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=20
    "DESCRIPTION" "Poslovni prostori"
    "RESULT_FIELDS" "ID,DESC"
    "RESULT_HEADERS" "Id,Desc"
    "RESULT_JOIN" =
"oci8://username:password@oracle||TABLE_NAME@OBJID@0@DESC||ID||1"
  END  # Metadata=20

...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:arm...@gm...]=20
> 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=20
> an advice on=20
> > 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=20
> that I need=20
> > to display in a query result table is held in Oracle 9i database.=20
> > These data are very dynamic so I have to dynamically=20
> connect to Oracle=20
> > and get the data when I click on a building with "Identify"=20
> or through=20
> > the attribute search.
> >=20
> > I don't know if anything is possible through the 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
> ----------------------------------------------------------------------
> > --- 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
> --
> 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