[mapguide-users] RE: Points from Sql/ODBC data source not showing

[soudemans]

Hi,

I'm back, and I'll admit it has been a while.  I have continued my research
in this fickle problem and have made some progress.  Part of this issue, not
earlier discussed, is that we also want to create a themed layer based on a
related table in SQL server.  I remember that in Mapguid 6.x this wasn't a
big deal, but for some reason it is in Enterprise.  After trying to get this
to work the traditional way, I found a suggestion to NOT do the join in
MapGuide.  The suggestion, when working with spatial data from and ArcSDE
GeoDatabase, was to create a spatial view, and then theme that spatial view
in MapGuide.  I did that and for the most part it worked, but not quite the
way I want it to.

Here is the thing, it works when I create an INNER JOIN, meaning that only
those records matching in both joined tables are shown.  BUT I want to show
all the records from the spatial data set and only those records that match
from the tabular joined data set.  In official SQL terms this is called an
OUTER JOIN.  Unfortunately the INNER JOIN works like a charm and the OUTER
JOIN does not.  This is where we come back to the old issue; the layer
simply does not show up in previews or on the website.

One way to get around this is to take the entire layer, display it in one
color (the color representing the null values) and then overlaying that with
the same layer themed based on an INNER JOIN where the items that would
ordinarily not have matching records are simply ignored.  Unfortunately, I
like stuff like this to be neat and tidy, and I would probably end up
tossing and turning at night thinking about the dual layer work-around.
Anyone else run into this issue?  


--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/Points-from-Sql-ODBC-data-source-not-showing-tp7021115p7067183.html
Sent from the MapGuide Users mailing list archive at Nabble.com.