I'm doing an Outer 1-Many Join. It's the Many that seems to be broken. Only the first match is joined. I would guess this may have been one of the issues in 1.2. Right now 2.0 isn't really an option for us. I have been testing, but we're not ready to move over to it. I have tried to make this same join in 2.0 but the test machine either isn't big enough or the join really consumes alot of resources. Chris
________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Dechant Sent: Monday, March 10, 2008 11:42 AM To: MapGuide Users Mail List Subject: RE: [mapguide-users] Feature Joins 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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
_______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users