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

[Armin B. <arm...@gm...>]

> 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.
> 

This is what I meant that 'it's not working'. The result array for one feature contains too many attributes. Ok, you could try in pmjson.js for the result display to check for this and add an additional row if the array of the result feature is longer than the one for the header. The problem is that with the current result structure in the json string all results from the join are in the same array, you do not know when one ends and the next starts.   

In any case you will have to decide how to display such a result. Having one building eg. appearing multiple times with all the common attributes and the zoom button, just because of additional attributes, might not look very intuitive and logical to users and one might at first glance see them as separate buildings. 


> 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.
> 

I wonder why nquery or search should not work, they should be identical for the display as normal query.

armin
-- 
Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! 
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer