[mapguide-users] MS SQL and SDF Join Problem

[Jackie C. Ng]

Joins may fail on strings if there are differences in case

See: http://trac.osgeo.org/mapguide/ticket/502

- Jackie


anakando wrote:
> 
> 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
>> 
>> 
> 
> 


-----
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-tp19448719p19452066.html
Sent from the MapGuide Users mailing list archive at Nabble.com.