[mapguide-users] MS SQL and SDF Join Problem

[anakando]

Sorry. I'm using MS SQL Server 2005 on windows xp sp2 

anakando wrote:
> 
> I'm using MS Server 2005. Forgot to tell you that sdf and database are
> linked using DSN. I still stuck on this problem. Everytime i set the sdf
> and db relationship to one-to-one,only the first row of data are shown,but
> when changed the relationship to one-to-many, all datas are shown but with
> a 'null' value. What makes me more curious, the problem happened only if
> the id that i set as primary key contains a space such as "ID 001". But
> when i removed the space (so it will be ID001), it joined successfully. I
> just wondering wether this problem is related to fdo capability or not..
> 
> 
> Jackie C. Ng wrote:
>> 
>> 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
>>>> 
>>>> 
>>> 
>>> 
>> 
>> 
> 
> 

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