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=DEV
> > 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
