What version of MS SQL Server are you using? - Jackie
anakando wrote: > > I guess there is not much i can do except exporting my sdf file to > external data and yes, this is the thing that most of the clients does not > like. > > > Rock Beans wrote: >> >> I have seen this issue with the SQL Spatial FDO provider as well. The >> join options don't work everything is always one-to-one which means >> only objects with data in the joined table show up on map, not good. I >> also have seen this on Oracle, this seems to be an ongoing FDO issue >> within MapGuide. Sorry I have no solutions or work around other than >> exporting your sdf/shp/etc with all the external data which means you >> don;t need the join anymore. This is not dynamic though, I realize >> this but ti works. It brings more data batch processing to the table >> which most clients do not like. >> >> The Rock >> >> On Thu, Sep 11, 2008 at 10:18 PM, anakando <[EMAIL PROTECTED]> 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 >>> -- >>> View this message in context: >>> http://www.nabble.com/MS-SQL-and-SDF-Join-Problem-tp19448719p19448719.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 >>> >> _______________________________________________ >> 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-tp19448719p19468030.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
