[mapguide-users] MS SQL and SDF Join Problem

[Jackie C. Ng]

What version of MS SQL Server are you using?

- Jackie


anakando wrote:
> 
> I guess there is not much i can do except exporting my sdf file to
> external data and yes, this is the thing that most of the clients does not
> like.
> 
> 
> Rock Beans wrote:
>> 
>> I have seen this issue with the SQL Spatial FDO provider as well. The
>> join options don't work everything is always one-to-one which means
>> only objects with data in the joined table show up on map, not good. I
>> also have seen this on Oracle, this seems to be an ongoing FDO issue
>> within MapGuide. Sorry I have no solutions or work around other than
>> exporting your sdf/shp/etc with all the external data which means you
>> don;t need the join anymore. This is not dynamic though, I realize
>> this but ti works. It brings more data batch processing to the table
>> which most clients do not like.
>> 
>> The Rock
>> 
>> On Thu, Sep 11, 2008 at 10:18 PM, anakando <anakando at yahoo.com> wrote:
>>>
>>> Hi guys..
>>> I faced a very big problem (i guess) since i cannot overcome this
>>> problem
>>> for almost 2 weeks! Let me simplify my problem. I have successful makes
>>> a
>>> join between my sdf file and MS SQL, but the problem is,after joining,it
>>> only show only first row data form MS SQL. The type of join is inner
>>> join,
>>> and relationship with secondary records is one-to-one. But when i change
>>> type of join to left outer join, it will show all the data from MS SQL
>>> but
>>> with a 'null' value! I have do some research about this problem but i
>>> can't
>>> find something useful for me. If somebody out there already experienced
>>> and
>>> successful solved the problem, please let me know. TQ
>>> --
>>> View this message in context:
>>> http://www.nabble.com/MS-SQL-and-SDF-Join-Problem-tp19448719p19448719.html
>>> Sent from the MapGuide Users mailing list archive at Nabble.com.
>>>
>>> _______________________________________________
>>> mapguide-users mailing list
>>> mapguide-users at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>>
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>> 
>> 
> 
> 


-----
http://themapguyde.blogspot.com

http://www.linkedin.com/in/jackieng
-- 
View this message in context: http://www.nabble.com/MS-SQL-and-SDF-Join-Problem-tp19448719p19468030.html
Sent from the MapGuide Users mailing list archive at Nabble.com.