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 >> <[EMAIL PROTECTED]>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 >>> [email protected] >>> http://lists.osgeo.org/mailman/listinfo/mapguide-users >>> >> >> >> >> -- >> Zac Spitzer - >> http://zacster.blogspot.com (My Blog) >> +61 405 847 168 >> >> _______________________________________________ >> mapguide-users mailing list >> [email protected] >> 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. _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
