<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:10pt"><DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif">I'm really sure that i have exactly the same record size on both tables. Any way, i use MySql as joined table. Maybe this is another weakness of MySql. I also has another problem with joined record. If i made a query which return no result then MGOS server will get crash. I have to start this service after that. Unfortunately MGOS 1.2 and MapStudio only support MySql. Hopefully next release will support postgis as well</DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"> </DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"> </DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif">Ary Sucaya</DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"><BR><BR> </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">----- Original Message ----<BR>From: Bruce Dechant <bruce.dechant@autodesk.com><BR>To: MapGuide Users Mail List <mapguide-users@lists.osgeo.org><BR>Sent: Wednesday, December 12, 2007 9:57:24 PM<BR>Subject: RE: [mapguide-users] FeatureReader<BR><BR>
<STYLE>
<!--
_filtered {font-family:"Cambria Math";panose-1:2 4 5 3 5 4 6 3 2 4;}
_filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
_filtered {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}
a:link, span.MsoHyperlink
{color:blue;text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
p.msochpdefault, li.msochpdefault, div.msochpdefault
{margin-right:0in;margin-left:0in;font-size:10.0pt;font-family:"Times New Roman", "serif";}
span.emailstyle17
{font-family:"Calibri", "sans-serif";color:#1F497D;}
span.EmailStyle19
{font-family:"Calibri", "sans-serif";color:#1F497D;}
.MsoChpDefault
{font-size:10.0pt;}
_filtered {margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{}
-->
</STYLE>
<DIV class=Section1>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri', 'sans-serif'">The reason you might be only getting a smaller subset of the data could be the type of join you setup.</SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri', 'sans-serif'">If the primary only has 100 records and the secondary has 300 records and you are doing a 1 to 1 join – you will only end up with 100 records in your result set.</SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri', 'sans-serif'"> </SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri', 'sans-serif'">Try creating a Left Outer join with a one-to-many relationship to see if all your data is returned.</SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri', 'sans-serif'"> </SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri', 'sans-serif'">Bruce</SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri', 'sans-serif'"> </SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri', 'sans-serif'"> </SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri', 'sans-serif'"> </SPAN></P>
<DIV>
<DIV style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<P class=MsoNormal><B><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma', 'sans-serif'">From:</SPAN></B><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma', 'sans-serif'"> mapguide-users-bounces@lists.osgeo.org [mailto:mapguide-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>ary sucaya<BR><B>Sent:</B> Tuesday, December 11, 2007 10:19 PM<BR><B>To:</B> MapGuide Users Mail List<BR><B>Subject:</B> Re: [mapguide-users] FeatureReader</SPAN></P></DIV></DIV>
<P class=MsoNormal> </P>
<DIV>
<DIV>
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial', 'sans-serif'">Thank for replying,<BR><BR>There is no exception. Here is my code:<BR><BR>try <BR>{ <BR>MgInitializeWebTier ($configFilePath); <BR>$userInfo = new MgUserInformation($sessionId); <BR>$siteConnection = new MgSiteConnection(); <BR>$siteConnection->Open($userInfo); <BR><BR>$resourceService = $siteConnection->CreateService(MgServiceType::ResourceService); <BR>$map = new MgMap($siteConnection);<BR>$map->Open($mapName);<BR><BR>$featureService = $siteConnection->CreateService(MgServiceType::FeatureService); <BR><BR>$queryOptions = new MgFeatureQueryOptions(); <BR>$queryOptions->SetFilter("FeatId > 0"); <BR>$layer = $map->GetLayers()->GetItem("District");<BR>$featureResId = new MgResourceIdentifier($layer->GetFeatureSourceId());<BR><BR>$featureReader = $featureService->SelectFeatures($featureResId,
$layer->GetFeatureClassName(), $queryOptions);<BR><BR>while ($featureReader->ReadNext()) <BR>{ <BR> echo $featureReader->GetInt32('DistrictID') . "<br />"; <BR>} <BR>$featureReader->Close(); <BR><BR>} <BR>catch (MgException $e) <BR>{ <BR> echo $e->GetMessage(); <BR> echo $e->GetDetails(); <BR>}<BR><BR>I have more than 300 record in layer District, but I can only see 100 record out of 300. I don't know what wrong..<BR><BR><BR>Thanx,<BR><BR><BR>Ary Sucaya</SPAN></P>
<DIV>
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt">----- Original Message ----<BR>From: Bruce Dechant <bruce.dechant@autodesk.com><BR>To: MapGuide Users Mail List <mapguide-users@lists.osgeo.org><BR>Sent: Tuesday, December 11, 2007 8:30:29 PM<BR>Subject: RE: [mapguide-users] FeatureReader</P>
<DIV>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri', 'sans-serif'">There is no limit. Is an exception being thrown? If so that would give you a clue as to why it is not working as expected.</SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri', 'sans-serif'"> </SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri', 'sans-serif'">Thanks,</SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri', 'sans-serif'">Bruce</SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri', 'sans-serif'"> </SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri', 'sans-serif'"> </SPAN></P>
<DIV>
<DIV style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<P class=MsoNormal><B><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma', 'sans-serif'">From:</SPAN></B><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma', 'sans-serif'"> mapguide-users-bounces@lists.osgeo.org [mailto:mapguide-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>ary sucaya<BR><B>Sent:</B> Monday, December 10, 2007 9:20 AM<BR><B>To:</B> Mapguide User<BR><B>Subject:</B> [mapguide-users] FeatureReader</SPAN></P></DIV></DIV>
<P class=MsoNormal> </P>
<DIV>
<DIV>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial', 'sans-serif'">Hii group,</SPAN></P></DIV>
<DIV>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial', 'sans-serif'"> </SPAN></P></DIV>
<DIV>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial', 'sans-serif'">I have a problem with feature reader. I have a sdf layer joined with external table and i can't make a looping for all of this records. It's always jump out the loop after 100 records. I tried the same code with different sdf layer without join to external layer, it's work well. </SPAN></P></DIV>
<DIV>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial', 'sans-serif'">Is there any limitation of joined layer in MapGuide 1.2? Anyone can help me?</SPAN></P></DIV>
<DIV>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial', 'sans-serif'"> </SPAN></P></DIV>
<DIV>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial', 'sans-serif'"> </SPAN></P></DIV>
<DIV>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial', 'sans-serif'">regards,</SPAN></P></DIV>
<DIV>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial', 'sans-serif'"> </SPAN></P></DIV>
<DIV>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial', 'sans-serif'">Ary Sucaya</SPAN></P></DIV></DIV>
<P class=MsoNormal> </P>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center>
<HR align=center width="100%" SIZE=1>
</DIV>
<P class=MsoNormal>Looking for last minute shopping deals? <A href="http://us.rd.yahoo.com/evt=51734/*http:/tools.search.yahoo.com/newsearch/category.php?category=shopping" target=_blank rel=nofollow>Find them fast with Yahoo! Search.</A></P></DIV></DIV>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial', 'sans-serif'"> </SPAN></P></DIV></DIV>
<P class=MsoNormal> </P>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center>
<HR align=center width="100%" SIZE=1>
</DIV>
<P class=MsoNormal>Be a better friend, newshound, and know-it-all with Yahoo! Mobile. <A href="http://us.rd.yahoo.com/evt=51733/*http:/mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ%20" target=_blank rel=nofollow>Try it now.</A></P></DIV></DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"><BR></DIV></div><br>
<hr size=1>Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. <a href="http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ "> Try it now.</a></body></html>