[mapguide-users] MGOS v2.0 join with other feature source issue

[David Nuell]

Hello All - 

This is a repost from a few days ago... I feel the trail might have gone
cold as the post gets pushed down the list.

Here is the problem - 

I am attempting to join my data to a database in mapguide Studio 2008.  I
have loaded my SHP and MS Access database resources and the SHP can be
displayed with no problem without a join.

My MS Access database has two tables that are related.

When I attempt to join the first table in the DB to my data resource, I can
see the joined attributes and polygons in the layers resource.  No issue
there.

when I attempt to join a SECOND table from the DB to my data resource, I can
see the joined attributes from the first and second tables, however I can
not see the polygons when I refresh the layer resource.  The scale is
appropriate, but no drawing appears.  If I remove the second join, the data
appears as normal.

Does anyone have a suggestion or have run into this issue?  I have even
created dummy data and simplified everything to make sure it was not just my
original data.

Any help would be appreciated.
Thanks listers.




David Nuell wrote:
> 
> Hi all -
> 
> I have MGOS v2.0 installed on a Win box with server 2003 installed.  I am
> also using Autodesk MapGuide Studio v 1.2.0.410 to build the web page.
> 
> I have connected my MS Access DB through OSGeo FDO Provider for ODBC and
> am attempting to join the tables within that DB with my data layer.
> 
> I am successful in connecting a single table to my data and it displays
> perfectly fine with the joined attributes.  When I attempt to connect a
> second table to the same data, the join works perfectly fine, however the
> data (polygons) do not display anymore.  When I remove the second table
> and refresh, it displays just fine again.
> 
> I have tried different tables, and in different orders however it seems
> that only a single table can be joined and be displayed.  Has anyone else
> run into this?  Is there a maximum number of joins allowed?
> 
> cheers.
> 
> 

-- 
View this message in context: http://www.nabble.com/MGOS-v2.0-join-with-other-feature-source-issue-tp16834759p16945870.html
Sent from the MapGuide Users mailing list archive at Nabble.com.