<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:10pt"><div><span>Ugh... I'm writing this message again because the new Yahoo mail is terrible.</span></div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: arial, helvetica, sans-serif; background-color: transparent; font-style: normal; "><span><br></span></div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: arial, helvetica, sans-serif; background-color: transparent; font-style: normal; "><span>The problem is not with the database. That is actually working perfectly and properly using variable binding.</span></div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: arial, helvetica, sans-serif; background-color: transparent; font-style: normal; "><span><br></span></div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: arial, helvetica, sans-serif; background-color: transparent;
font-style: normal; "><span>The problem is with the identify template. Specifically this line:</span></div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: arial, helvetica, sans-serif; background-color: transparent; font-style: normal; "><span> <a href="javascript:GeoMOOSE.startService('modify_polygon', {'feature:polygon_id' : '[polygon_id]','feature:wkb_geometry' : '[wkt_geometry]', 'feature:title' : '[title]', 'feature:owner' : '[owner]'})">Edit</a><br></span></div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: arial, helvetica, sans-serif; background-color: transparent; font-style: normal; "><span><br></span></div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: arial, helvetica, sans-serif; background-color: transparent; font-style: normal; ">This modification should make things editable, though your users may be unhappy with the "%27" displayed when they are editing the feature's
title:</div><div><br></div><div> <a href="javascript:GeoMOOSE.startService('modify_polygon', {'feature:polygon_id' : '[polygon_id]','feature:wkb_geometry' : '[wkt_geometry]', 'feature:title' : '[title escape="url"]', 'feature:owner' : '[owner escape="url"]'})">Edit</a><br></div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: arial, helvetica, sans-serif; background-color: transparent; font-style: normal; "><br></div><div>Vector handling needs some major improvement.</div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: arial, helvetica, sans-serif; background-color: transparent; font-style: normal; "><br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><div style="font-size: 10pt; font-family: arial, helvetica, sans-serif; "><div style="font-size: 12pt; font-family: 'times new roman', 'new york', times, serif; "><font size="2" face="Arial"><hr
size="1"><b><span style="font-weight:bold;">From:</span></b> Dan Little <danlittle@yahoo.com><br><b><span style="font-weight: bold;">To:</span></b> "groberts@wendlergs.com" <groberts@wendlergs.com>; "geomoose-users@lists.sourceforge.net" <geomoose-users@lists.sourceforge.net><br><b><span style="font-weight: bold;">Sent:</span></b> Tuesday, April 5, 2011 11:26 PM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: [Geomoose-users] Feature Editor Problem<br></font><br> <div id="yiv275082076"><div style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-size: 10pt; font-family: arial, helvetica, sans-serif; "><div>I would imagine that it's because variable binding is not happening for that request.</div><div><br></div><div style="color: rgb(0, 0, 0); font-size: 13px; background-color: transparent; font-style: normal; font-family: arial, helvetica, sans-serif; ">Worst case scenario: I can probably send you a patch
that escapes single quotes (apostrophes)</div><div><br></div><div>Best case scenario: I fix it for real using PDO in 2.4.</div><div><br><blockquote style="border-left:2px solid rgb(16, 16, 255);margin-left:5px;padding-left:5px;"><div style="font-size: 10pt; font-family: arial, helvetica, sans-serif; "><div style="font-size: 12pt; font-family: times, serif; "><font size="2" face="Arial"><hr size="1"><b><span style="font-weight:bold;">From:</span></b> Gregory Roberts | Wendler
<groberts@wendlergs.com><br><b><span style="font-weight:bold;">To:</span></b> geomoose-users@lists.sourceforge.net<br><b><span style="font-weight:bold;">Sent:</span></b> Tuesday, April 5, 2011 4:55 PM<br><b><span style="font-weight:bold;">Subject:</span></b> Re: [Geomoose-users] Feature Editor Problem<br></font><br>
<div id="yiv275082076">
<style>
<!--
#yiv275082076
p.yiv275082076MsoNormal, #yiv275082076 li.yiv275082076MsoNormal, #yiv275082076 div.yiv275082076MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman";}
#yiv275082076 a:link, #yiv275082076 span.yiv275082076MsoHyperlink
{color:blue;text-decoration:underline;}
#yiv275082076 a:visited, #yiv275082076 span.yiv275082076MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
#yiv275082076 p.yiv275082076MsoAutoSig, #yiv275082076 li.yiv275082076MsoAutoSig, #yiv275082076 div.yiv275082076MsoAutoSig
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman";}
#yiv275082076 span.yiv275082076EmailStyle17
{font-family:Arial;color:windowtext;}
#yiv275082076 filtered {margin:1.0in 1.25in 1.0in 1.25in;}
#yiv275082076 div.yiv275082076Section1
{}
-->
</style>
<div class="yiv275082076Section1">
<div class="yiv275082076MsoAutoSig"><font size="3" face="Times New Roman"><span style="font-size:12.0pt;">Hello,</span></font></div>
<div class="yiv275082076MsoAutoSig"><font size="3" face="Times New Roman"><span style="font-size:12.0pt;"> </span></font></div>
<div class="yiv275082076MsoAutoSig"><font size="3" face="Times New Roman"><span style="font-size:12.0pt;">We have had an ongoing problem with the feature editor tool that occurs
when a user creates or edits a feature and inputs an apostrophe into a field.
Once the feature has been saved with an apostrophe the feature can no longer be
edited which results in us having to delete the apostrophe through the back-end
in postgres. We have already informed our users of this problem but still have
this occur a few times a week.</span></font></div>
<div class="yiv275082076MsoAutoSig"><font size="3" face="Times New Roman"><span style="font-size:12.0pt;"> </span></font></div>
<div class="yiv275082076MsoAutoSig"><font size="3" face="Times New Roman"><span style="font-size:12.0pt;">Does anyone else have any experience with this or any ideas as to how
to go about fixing it? Thanks very much.</span></font></div>
<div class="yiv275082076MsoAutoSig"><font size="3" face="Times New Roman"><span style="font-size:12.0pt;"> </span></font></div>
<div class="yiv275082076MsoAutoSig"><font size="3" face="Times New Roman"><span style="font-size:12.0pt;">Gregory</span></font></div>
<div class="yiv275082076MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt;"> </span></font></div>
</div>
</div><br>------------------------------------------------------------------------------<br>Xperia(TM) PLAY<br>It's a major breakthrough. An authentic gaming<br>smartphone on the nation's most reliable network.<br>And it wants your games.<br><a rel="nofollow" target="_blank" href="http://p.sf.net/sfu/verizon-sfdev">http://p.sf.net/sfu/verizon-sfdev</a><br>_______________________________________________<br>Geomoose-users mailing list<br><a rel="nofollow" ymailto="mailto:Geomoose-users@lists.sourceforge.net" target="_blank" href="mailto:Geomoose-users@lists.sourceforge.net">Geomoose-users@lists.sourceforge.net</a><br><a rel="nofollow" target="_blank" href="https://lists.sourceforge.net/lists/listinfo/geomoose-users">https://lists.sourceforge.net/lists/listinfo/geomoose-users</a><br><br><br></div></div></blockquote></div></div></div><br>------------------------------------------------------------------------------<br>Xperia(TM) PLAY<br>It's a major
breakthrough. An authentic gaming<br>smartphone on the nation's most reliable network.<br>And it wants your games.<br><a href="http://p.sf.net/sfu/verizon-sfdev" target="_blank">http://p.sf.net/sfu/verizon-sfdev</a><br>_______________________________________________<br>Geomoose-users mailing list<br><a ymailto="mailto:Geomoose-users@lists.sourceforge.net" href="mailto:Geomoose-users@lists.sourceforge.net">Geomoose-users@lists.sourceforge.net</a><br><a href="https://lists.sourceforge.net/lists/listinfo/geomoose-users" target="_blank">https://lists.sourceforge.net/lists/listinfo/geomoose-users</a><br><br><br></div></div></blockquote></div></div></body></html>