<div dir="ltr"><div><div><div><div><div><br></div>Hi Mark,<br><br></div>If I understood Jeff's email correctly, you should only have to make the correction in the MAP file, and you should not have to touch any PHP files.<br><br></div>Can you confirm if you tried only editing the MAP file with the correction? The key line is the DATA line below...<br><br></div>Tanya<br><br></div>---------------- from Jeff's email --------------- > ><br><div><br><span class="im"> LAYER<br>
TYPE LINE<br>
STATUS ON<br>
NAME 'selected'<br>
CONNECTIONTYPE OGR<br></span>
CONNECTION '/ms4w/tmp/ms_tmp/select_132761447356573.db'<br>
DATA 'select wkt_geometry from features' <br><span class="im">
CLASS<br>
STYLE<br>
OUTLINECOLOR 255 255 0<br>
COLOR 0 0 0<br>
END<br>
END<br>
END<br>
END #map</span><br><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Dec 7, 2015 at 11:19 AM, Mark Volz <span dir="ltr"><<a href="mailto:MarkVolz@co.lyon.mn.us" target="_blank">MarkVolz@co.lyon.mn.us</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Eli,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">My best guess is that MapServer on Linux allows a shorthand sql query to SpatialLite Databases and MS4W does not. For Example:<u></u><u></u></span></p>
<p><u></u><span style="font-size:11.0pt;font-family:Symbol;color:#1f497d"><span>·<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">DATA ‘features’
</span><span style="font-size:11.0pt;font-family:Wingdings;color:#1f497d">ß</span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">This shorthand sql query might only work in Linux Mapserver.<u></u><u></u></span></p>
<p><u></u><span style="font-size:11.0pt;font-family:Symbol;color:#1f497d"><span>·<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">DATA ‘SELECT * FROM features’
</span><span style="font-size:11.0pt;font-family:Wingdings;color:#1f497d">ß</span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> This equivalent sql statement might work in both the Linux and MS4W flavors of MapServer.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Sincerely,<u></u><u></u></span></p>
<p class="MsoNormal"><b><span style="font-family:"Calibri","sans-serif";color:#1f497d">Mark Volz<u></u><u></u></span></b></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<div style="border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt">
<div>
<div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Eli Adam [mailto:<a href="mailto:eadam@co.lincoln.or.us" target="_blank">eadam@co.lincoln.or.us</a>]
<br>
<b>Sent:</b> Monday, December 07, 2015 11:31 AM<br>
<b>To:</b> Mark Volz<br>
<b>Cc:</b> <a href="mailto:geomoose-users@lists.osgeo.org" target="_blank">geomoose-users@lists.osgeo.org</a>; <a href="mailto:tchaddad@gmail.com" target="_blank">tchaddad@gmail.com</a><br>
<b>Subject:</b> Re: [Geomoose-users] [geomoose] Highlighting missing from select feature tool - MS4W specific (#107)<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
<div><span class="">
<p class="MsoNormal">On Mon, Dec 7, 2015 at 9:20 AM, Mark Volz <<a href="mailto:MarkVolz@co.lyon.mn.us" target="_blank">MarkVolz@co.lyon.mn.us</a>> wrote:<u></u><u></u></p>
<div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Hello,</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">A while back I reported an issue with the selection results not displaying on GeoMOOSE specifically
with MS4W. Thanks to Jeff and Tanya the highlights now work!</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span><u></u><u></u></p>
<p class="MsoNormal">Changes in c:\ms4w\apps\geomoose2\php\highlight.php<u></u><u></u></p>
<p class="MsoNormal">Line 47<br>
Replace: DATA 'features' <br>
With: DATA 'select wkt_geometry from features'<u></u><u></u></p>
<p class="MsoNormal">Line 66<br>
Replace: DATA 'selection'<br>
With: DATA 'select area, wkt_geometry from selection'<u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">We might want to look for a generalized approach that will work in all cases and not require people to edit highlight.php.
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><br>
<u></u><u></u></p>
</div>
<blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Questions:</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span><u></u><u></u></p>
<p><span style="font-size:11.0pt;font-family:Symbol;color:#1f497d">·</span><span style="font-size:7.0pt;color:#1f497d">
</span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Perhaps it might be a good idea to verify that these changes don’t crash the Linux version of GeoMOOSE.</span><u></u><u></u></p>
</div>
</div>
</blockquote>
</span><div>
<p class="MsoNormal">Is this about operating system or data source type? It sounds like it might be more about shapefile vs database than operating system.
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><br>
<u></u><u></u></p>
</div>
<blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<p><span style="font-size:11.0pt;font-family:Symbol;color:#1f497d">·</span><span style="font-size:7.0pt;color:#1f497d">
</span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">In GitHub how do we close or mark a ticket as answered?</span><u></u><u></u></p>
</div>
</div>
</blockquote><span class="">
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">When logged in, I think at the bottom where you can comment is a button that says "close issue."<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Best regards, Eli<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</span><blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Sincerely,</span><u></u><u></u></p>
<p class="MsoNormal"><b><span style="font-family:"Calibri","sans-serif";color:#1f497d">Mark Volz</span></b><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span><u></u><u></u></p>
<div style="border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt"><span class="">
<div>
<div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> TC Haddad [mailto:<a href="mailto:notifications@github.com" target="_blank">notifications@github.com</a>]
<br>
<b>Sent:</b> Friday, December 04, 2015 4:33 PM<br>
<b>To:</b> geomoose/geomoose<br>
<b>Cc:</b> Mark Volz<br>
<b>Subject:</b> Re: [geomoose] Highlighting missing from select feature tool - MS4W specific (#107)</span><u></u><u></u></p>
</div>
</div>
</span><div>
<div><span class="">
<p class="MsoNormal"> <u></u><u></u></p>
<p>Hi Mark, I think this is the ticket for the issue that Jeff just commented on on the mailing list:<br>
<a href="https://lists.osgeo.org/pipermail/geomoose-users/2015-December/005813.html" target="_blank">https://lists.osgeo.org/pipermail/geomoose-users/2015-December/005813.html</a><br>
Can you try his solution and report back and close this issue if his solution works for you?
<u></u><u></u></p>
</span><p><span style="color:#666666">—<span class=""><br>
Reply to this email directly or <a href="https://github.com/geomoose/geomoose/issues/107#issuecomment-162100544" target="_blank">
view it on GitHub</a>.</span></span><u></u><u></u></p>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><br><span class="">
_______________________________________________<br>
Geomoose-users mailing list<br>
<a href="mailto:Geomoose-users@lists.osgeo.org" target="_blank">Geomoose-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/geomoose-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/geomoose-users</a><u></u><u></u></span></p>
</blockquote>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
</div>
</div>
</div>
</blockquote></div><br></div>