<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">Well, finally i infer that Mapguide selection still contain a hidden bug. Here is my simple php:</DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"> </DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"><FONT size=2>
<P>$regionGeometryData = $featureReader->GetGeometry('Geometry');</P>
<P></P>
<P>$agfReaderWriter = new MgAgfReaderWriter();</P>
<P>$regionGeometry = $agfReaderWriter->Read($regionGeometryData);</P>
<P></P>
<P>$queryOptions = new MgFeatureQueryOptions();</P></FONT></DIV><FONT size=2>
<P style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif">$queryOptions->SetSpatialFilter('BOUNDARY', $regionGeometry, MgFeatureSpatialOperations::Intersects);</P>
<P style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"> </P><FONT size=2>
<P>$layer = $map->GetLayers()->GetItem("INDEX");</P>
<P>$featureReader = $layer->SelectFeatures($queryOptions);</P></FONT>
<P></FONT> </P>
<P>$regionGeometryData comes from SDF file. By this geometry, i try to select another layer that is intersects with this. MGOS give me some records in layer INDEX that is not have an intersection even far away from $regionGeometryData.</P>
<P> </P>
<P>I will try to file a ticket soon for this issues..</P>
<P> </P>
<P> </P>
<P>Ary Sucaya</P>
<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: Jason Birch <Jason.Birch@nanaimo.ca><BR>To: MapGuide Users Mail List <mapguide-users@lists.osgeo.org><BR>Sent: Thursday, November 29, 2007 10:38:22 PM<BR>Subject: RE: [mapguide-users] Insert Order In MySql Affect to theMapGuideSelection?<BR><BR>
<STYLE type=text/css>DIV {
MARGIN:0px;}
</STYLE>
<DIV dir=ltr align=left><SPAN class=935132121-29112007><FONT face=Arial color=#0000ff size=2>The bounding box operations would explain why you are getting a polygon selected even when you click outside of its boundary. Read the note at the top of this page if you would like to confirm that this is indeed MySQL's behaviour: <A href="http://tinyurl.com/2mk9aa" target=_blank rel=nofollow>http://tinyurl.com/2mk9aa</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=935132121-29112007><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=935132121-29112007><FONT face=Arial color=#0000ff size=2>I'm not a heavy MySQL user, but I'm pretty sure that insertion order affects the order that rows are returned in (unless you're explicitly ordering them, and I am pretty sure that MapGuide does not). If this is the case, then in combination with #313 this might explain why you are getting different polygons within the multipolygon selected? Maybe I don't understand the issue properly.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=935132121-29112007><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=935132121-29112007><FONT face=Arial color=#0000ff size=2>If this works with multipolygon SDF files with no issues though, it is either a problem with MySQL itself, or a problem with the MySQL FDO provider. I would strongly encourage you to file a ticket on the FDO Trac instance (instructions here: <A href="http://trac.osgeo.org/fdo/wiki/SubmitTicket" target=_blank rel=nofollow>http://trac.osgeo.org/fdo/wiki/SubmitTicket</A> ). For best results, please include a description (preferably with small screenshots illustrating the problem) and include a mysqldump of the geometry that is causing the problem to allow the developers to easily reproduce it.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=935132121-29112007><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=935132121-29112007><FONT face=Arial color=#0000ff size=2>Jason</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=935132121-29112007></SPAN><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> ary sucaya<BR><B>Subject:</B> Re: [mapguide-users] Insert Order In MySql Affect to theMapGuideSelection?<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif">
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"><SPAN class=388000620-29112007><FONT face=Arial color=#810081 size=2><A href="http://trac.osgeo.org/mapguide/ticket/313" target=_blank rel=nofollow>http://trac.osgeo.org/mapguide/ticket/313</A> is not what i'm seeing now. That's another problem of multipolygon. What i don't understand is why the sequence of records insertion affect MGOS select behaviour? If MySql perform geometric operation only on their bounding box, then 'my selection problem' will always happens even i change the sequence of records insertion </FONT></SPAN></DIV></DIV></DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"><BR></DIV></div><br>
<hr size=1>Never miss a thing. <a href="http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs"> Make Yahoo your homepage.</a>
</body></html>