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 > > -- 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. _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
