[mapguide-users] MS SQL and SDF Join Problem

[anakando]

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
> 
> 

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