[mapguide-users] Feature Joins

[Bruce Dechant]

Chris,

MGOS 1.2 did have some join issues and I believe you might be encountering one of them. Are you doing an inner or outer join?
With MGOS 2.0 I have joined SDFs with Access many times in the following cases:

Inner 1-1
Inner 1-Many
Outer 1-1
Outer 1-Many

The above worked for my use cases with MGOS 2.0. Would you be able to try MGOS 2.0?

Thanks,
Bruce


From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Chris Tallman
Sent: Monday, March 10, 2008 7:28 AM
To: MapGuide Users Mail List
Subject: [mapguide-users] Feature Joins

Morning all.

Is anyone seeing issues with joins, using one-to-many?  I have an sdf feature joined to a MSAccess file.  I'm only seeing the first join per feature, the second, third and on are ignored.

I'm on MGOS 1.2 IIS 6 .net install.

I've created the same join in autocad and I don't have a problem.

More detail:  I have a sdf feature source that is buildings.  My database has a list of majors.  Both have a Building ID.  One id per building. Multiple majors per building.  I'm trying to create layers based on the join that displays buildings based on majors.  If a building has multiple majors it only shows up once and it seems to only be the first match it comes across.  So I guess it's acting more like a one-to-one join.

I hope this enough explanation someone will be able to help me out.  If not let me know and I can try and explain more.

Chris Tallman
Director of GIS Operations
Innovation Mapping, LLC
260-356-9074

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20080310/86ad8b81/attachment.html