<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Try linking the tables with integer columns, that is usually the only
stable solution.<br>
<pre class="moz-signature" cols="72">Regards, Kenneth Skovhede, GEOGRAF A/S
</pre>
<br>
<br>
anakando skrev:
<blockquote cite="mid:19450781.post@talk.nabble.com" type="cite">
<pre wrap="">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:
</pre>
<blockquote type="cite">
<pre wrap="">also which version are you running 2.0.1?
On Fri, Sep 12, 2008 at 2:54 PM, Jackie C. Ng
<a class="moz-txt-link-rfc2396E" href="mailto:jumpinjackie@gmail.com"><jumpinjackie@gmail.com></a>wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Are you joining on strings?
- Jackie
anakando wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi guys..
I faced a very big problem (i guess) since i cannot overcome this
</pre>
</blockquote>
<pre wrap="">problem
</pre>
<blockquote type="cite">
<pre wrap="">for almost 2 weeks! Let me simplify my problem. I have successful makes
</pre>
</blockquote>
<pre wrap="">a
</pre>
<blockquote type="cite">
<pre wrap="">join between my sdf file and MS SQL, but the problem is,after
</pre>
</blockquote>
<pre wrap="">joining,it
</pre>
<blockquote type="cite">
<pre wrap="">only show only first row data form MS SQL. The type of join is inner
</pre>
</blockquote>
<pre wrap="">join,
</pre>
<blockquote type="cite">
<pre wrap="">and relationship with secondary records is one-to-one. But when i
</pre>
</blockquote>
<pre wrap="">change
</pre>
<blockquote type="cite">
<pre wrap="">type of join to left outer join, it will show all the data from MS SQL
</pre>
</blockquote>
<pre wrap="">but
</pre>
<blockquote type="cite">
<pre wrap="">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
</pre>
</blockquote>
<pre wrap="">
-----
<a class="moz-txt-link-freetext" href="http://themapguyde.blogspot.com">http://themapguyde.blogspot.com</a>
<a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/jackieng">http://www.linkedin.com/in/jackieng</a>
--
View this message in context:
<a class="moz-txt-link-freetext" href="http://www.nabble.com/MS-SQL-and-SDF-Join-Problem-tp19448719p19449417.html">http://www.nabble.com/MS-SQL-and-SDF-Join-Problem-tp19448719p19449417.html</a>
Sent from the MapGuide Users mailing list archive at Nabble.com.
_______________________________________________
mapguide-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a>
</pre>
</blockquote>
<pre wrap="">
--
Zac Spitzer -
<a class="moz-txt-link-freetext" href="http://zacster.blogspot.com">http://zacster.blogspot.com</a> (My Blog)
+61 405 847 168
_______________________________________________
mapguide-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a>
</pre>
</blockquote>
<pre wrap=""><!---->
</pre>
</blockquote>
</body>
</html>