[ZS1] Re: [mapguide-users] MS SQL and SDF Join Problem

[Kenneth Skovhede, GEOGRAF A/S]

Try linking the tables with integer columns, that is usually the only 
stable solution.

Regards, Kenneth Skovhede, GEOGRAF A/S



anakando skrev:
> Yes..my MG version is 2.0.1..Here is my situation. I have database that
> contain 2 tables (as example). Both of tables are linked to SDF file using
> unique id,and both data type are set to 'varchar'. Out of my curiosity, only
> 1 table are successfull linked to sdf, but the other one are not. It only
> show the first row of data.I am frustated
>
>
> zspitzer wrote:
>   
>> also which version are you running 2.0.1?
>>
>> On Fri, Sep 12, 2008 at 2:54 PM, Jackie C. Ng
>> <jumpinjackie at gmail.com>wrote:
>>
>>     
>>> Are you joining on strings?
>>>
>>> - Jackie
>>>
>>>
>>> anakando 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
>>>>
>>>>         
>>> -----
>>> 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-tp19448719p19449417.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
>>>
>>>       
>>
>> -- 
>> Zac Spitzer -
>> http://zacster.blogspot.com (My Blog)
>> +61 405 847 168
>>
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>>     
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20080912/d2f26c83/attachment.html