<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:10pt"><div><span>Try removing the quotes around "url" in the escape statement.</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><span>Any chance this site is accessible from the outside?</span></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 new roman', 'new york', 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> 'Dan Little' <danlittle@yahoo.com>;
geomoose-users@lists.sourceforge.net<br><b><span style="font-weight: bold;">Sent:</span></b> Wednesday, April 6, 2011 9:56 AM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: [Geomoose-users] Feature Editor Problem<br></font><br> <div id="yiv1163934639">
<style>
<!--
#yiv1163934639 filtered {margin:1.0in 1.25in 1.0in 1.25in;}
#yiv1163934639
_filtered #yiv1163934639 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}
_filtered #yiv1163934639 {font-family:Times;panose-1:2 2 6 3 5 4 5 2 3 4;}
#yiv1163934639
#yiv1163934639 p.yiv1163934639MsoNormal, #yiv1163934639 li.yiv1163934639MsoNormal, #yiv1163934639 div.yiv1163934639MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman";}
#yiv1163934639 a:link, #yiv1163934639 span.yiv1163934639MsoHyperlink
{color:blue;text-decoration:underline;}
#yiv1163934639 a:visited, #yiv1163934639 span.yiv1163934639MsoHyperlinkFollowed
{color:blue;text-decoration:underline;}
#yiv1163934639 p.yiv1163934639MsoAutoSig, #yiv1163934639 li.yiv1163934639MsoAutoSig, #yiv1163934639 div.yiv1163934639MsoAutoSig
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman";}
#yiv1163934639 p.yiv1163934639msonormal, #yiv1163934639 li.yiv1163934639msonormal, #yiv1163934639 div.yiv1163934639msonormal
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman";}
#yiv1163934639 p.yiv1163934639msoautosig, #yiv1163934639 li.yiv1163934639msoautosig, #yiv1163934639 div.yiv1163934639msoautosig
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman";}
#yiv1163934639 p.yiv1163934639msonormal1, #yiv1163934639 li.yiv1163934639msonormal1, #yiv1163934639 div.yiv1163934639msonormal1
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman";}
#yiv1163934639 span.yiv1163934639msohyperlink1
{color:blue;text-decoration:underline;}
#yiv1163934639 span.yiv1163934639msohyperlinkfollowed1
{color:purple;text-decoration:underline;}
#yiv1163934639 p.yiv1163934639msoautosig1, #yiv1163934639 li.yiv1163934639msoautosig1, #yiv1163934639 div.yiv1163934639msoautosig1
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman";}
#yiv1163934639 span.yiv1163934639emailstyle171
{font-family:Arial;color:windowtext;}
#yiv1163934639 span.yiv1163934639EmailStyle27
{font-family:Arial;color:navy;}
_filtered #yiv1163934639 {margin:1.0in 1.25in 1.0in 1.25in;}
#yiv1163934639 div.yiv1163934639Section1
{}
-->
</style>
<div class="yiv1163934639Section1">
<div>
<div class="yiv1163934639MsoAutoSig"><font size="3" color="navy" face="Times New Roman"><span style="font-size:12.0pt;color:navy;">This doesn't seem to work. I get the error
message: unterminated string literal when editing any feature with or without
an apostrophe. </span></font></div>
<div class="yiv1163934639MsoAutoSig"><font size="3" color="navy" face="Times New Roman"><span style="font-size:12.0pt;color:navy;"> </span></font></div>
</div>
<div class="yiv1163934639MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; color: navy; font-family: Arial; "> </span></font></div>
<div>
<div class="yiv1163934639MsoNormal" align="center" style="text-align:center;"><font size="3" face="Times New Roman"><span style="font-size:12.0pt;">
<hr size="2" width="100%" align="center" tabindex="-1">
</span></font></div>
<div class="yiv1163934639MsoNormal"><b><font size="2" face="Tahoma"><span style="font-size: 10pt; font-weight: bold; font-family: Tahoma; ">From:</span></font></b><font size="2" face="Tahoma"><span style="font-size: 10pt; font-family: Tahoma; "> Dan Little
[mailto:danlittle@yahoo.com] <br>
<b><span style="font-weight:bold;">Sent:</span></b> Wednesday, April 06, 2011
8:16 AM<br>
<b><span style="font-weight:bold;">To:</span></b> Dan Little;
groberts@wendlergs.com ;
geomoose-users@lists.sourceforge.net<br>
<b><span style="font-weight:bold;">Subject:</span></b> Re: [Geomoose-users]
Feature Editor Problem</span></font></div>
</div>
<div class="yiv1163934639MsoNormal"><font size="3" face="Times New Roman"><span style="
font-size:12.0pt;"> </span></font></div>
<div>
<div>
<div class="yiv1163934639MsoNormal" style="background:white;"><font size="2" color="black" face="Arial"><span style="font-size: 10pt; color: black; font-family: Arial; ">Ugh...
I'm writing this message again because the new Yahoo mail is terrible.</span></font></div>
</div>
<div>
<div class="yiv1163934639MsoNormal"><font size="2" color="black" face="Arial"><span style="font-size: 10pt; color: black; font-family: Arial; "> </span></font></div>
</div>
<div>
<div class="yiv1163934639MsoNormal"><font size="2" color="black" face="Arial"><span style="font-size: 10pt; color: black; font-family: Arial; ">The problem is not with the database.
That is actually working perfectly and properly using variable binding.</span></font></div>
</div>
<div>
<div class="yiv1163934639MsoNormal"><font size="2" color="black" face="Arial"><span style="font-size: 10pt; color: black; font-family: Arial; "> </span></font></div>
</div>
<div>
<div class="yiv1163934639MsoNormal"><font size="2" color="black" face="Arial"><span style="font-size: 10pt; color: black; font-family: Arial; ">The problem is with the identify
template. Specifically this line:</span></font></div>
</div>
<div>
<div class="yiv1163934639MsoNormal"><font size="2" color="black" face="Arial"><span style="font-size: 10pt; color: black; font-family: Arial; "> <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></span></font></div>
</div>
<div>
<div class="yiv1163934639MsoNormal"><font size="2" color="black" face="Arial"><span style="font-size: 10pt; color: black; font-family: Arial; "> </span></font></div>
</div>
<div>
<div class="yiv1163934639MsoNormal"><font size="2" color="black" face="Arial"><span style="font-size: 10pt; color: black; font-family: Arial; ">This modification should make things
editable, though your users may be unhappy with the "%27" displayed
when they are editing the feature's title:</span></font></div>
</div>
<div>
<div class="yiv1163934639MsoNormal" style="background:white;"><font size="2" color="black" face="Arial"><span style="font-size: 10pt; color: black; font-family: Arial; "> </span></font></div>
</div>
<div>
<div class="yiv1163934639MsoNormal" style="background:white;"><font size="2" color="black" face="Arial"><span style="font-size: 10pt; color: black; font-family: Arial; "> <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></span></font></div>
</div>
<div>
<div class="yiv1163934639MsoNormal"><font size="2" color="black" face="Arial"><span style="font-size: 10pt; color: black; font-family: Arial; "> </span></font></div>
</div>
<div>
<div class="yiv1163934639MsoNormal" style="background:white;"><font size="2" color="black" face="Arial"><span style="font-size: 10pt; color: black; font-family: Arial; ">Vector
handling needs some major improvement.</span></font></div>
</div>
<div>
<blockquote style="border:none;border-left:solid #1010FF 1.5pt;padding:0in 0in 0in 4.0pt;margin-left:3.75pt;margin-top:5.0pt;margin-bottom:5.0pt;">
<div class="yiv1163934639MsoNormal"><font size="2" color="black" face="Arial"><span style="font-size: 10pt; color: black; font-family: Arial; "> </span></font></div>
<div>
<div>
<div class="yiv1163934639MsoNormal" align="center" style="text-align:center;"><font size="2" color="black" face="Arial"><span style="font-size: 10pt; color: black; font-family: Arial; ">
<hr size="1" width="100%" align="center">
</span></font></div>
<div class="yiv1163934639MsoNormal" style="margin-bottom:12.0pt;"><b><font size="2" color="black" face="Arial"><span style="font-size: 10pt; color: black; font-weight: bold; font-family: Arial; ">From:</span></font></b><font size="2" color="black" face="Arial"><span style="font-size: 10pt; color: black; font-family: Arial; "> 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</span></font><font color="black"><span style="color:black;"></span></font></div>
<div id="yiv1163934639">
<div>
<div>
<div class="yiv1163934639MsoNormal" style="background:white;"><font size="2" color="black" face="Arial"><span style="font-size: 10pt; color: black; font-family: Arial; ">I would
imagine that it's because variable binding is not happening for that request.</span></font></div>
</div>
<div>
<div class="yiv1163934639MsoNormal" style="background:white;"><font size="2" color="black" face="Arial"><span style="font-size: 10pt; color: black; font-family: Arial; "> </span></font></div>
</div>
<div>
<div class="yiv1163934639MsoNormal"><font size="2" color="black" face="Arial"><span style="font-size: 10pt; color: black; font-family: Arial; ">Worst case scenario: I can probably send
you a patch that escapes single quotes (apostrophes)</span></font></div>
</div>
<div>
<div class="yiv1163934639MsoNormal" style="background:white;"><font size="2" color="black" face="Arial"><span style="font-size: 10pt; color: black; font-family: Arial; "> </span></font></div>
</div>
<div>
<div class="yiv1163934639MsoNormal" style="background:white;"><font size="2" color="black" face="Arial"><span style="font-size: 10pt; color: black; font-family: Arial; ">Best
case scenario: I fix it for real using PDO in 2.4.</span></font></div>
</div>
<div>
<blockquote style="border:none;border-left:solid #1010FF 1.5pt;padding:0in 0in 0in 4.0pt;margin-left:3.75pt;margin-top:5.0pt;margin-bottom:5.0pt;">
<div class="yiv1163934639MsoNormal" style="background:white;"><font size="2" color="black" face="Arial"><span style="font-size: 10pt; color: black; font-family: Arial; "> </span></font></div>
<div>
<div>
<div class="yiv1163934639MsoNormal" align="center" style="text-align:center;background:white;"><font size="2" color="black" face="Arial"><span style="font-size: 10pt; color: black; font-family: Arial; ">
<hr size="1" width="100%" align="center">
</span></font></div>
<div class="yiv1163934639MsoNormal" style="margin-bottom:12.0pt;background:white;"><b><font size="2" color="black" face="Arial"><span style="font-size: 10pt; color: black; font-weight: bold; font-family: Arial; ">From:</span></font></b><font size="2" color="black" face="Arial"><span style="font-size: 10pt; color: black; font-family: Arial; ">
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</span></font><font color="black" face="Times"><span style="color: black; font-family: Times; "></span></font></div>
<div id="yiv1163934639">
<div>
<div>
<div class="yiv1163934639MsoNormal" style="background:white;"><font size="3" color="black" face="Times New Roman"><span style="font-size:12.0pt;color:black;">Hello,</span></font><font color="black" face="Times"><span style="color: black; font-family: Times; "></span></font></div>
</div>
<div>
<div class="yiv1163934639MsoNormal" style="background:white;"><font size="3" color="black" face="Times New Roman"><span style="font-size:12.0pt;color:black;"> </span></font><font color="black" face="Times"><span style="color: black; font-family: Times; "></span></font></div>
</div>
<div>
<div class="yiv1163934639MsoNormal" style="background:white;"><font size="3" color="black" face="Times New Roman"><span style="font-size:12.0pt;color:black;">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><font color="black" face="Times"><span style="color: black; font-family: Times; "></span></font></div>
</div>
<div>
<div class="yiv1163934639MsoNormal" style="background:white;"><font size="3" color="black" face="Times New Roman"><span style="font-size:12.0pt;color:black;"> </span></font><font color="black" face="Times"><span style="color: black; font-family: Times; "></span></font></div>
</div>
<div>
<div class="yiv1163934639MsoNormal" style="background:white;"><font size="3" color="black" face="Times New Roman"><span style="font-size:12.0pt;color:black;">Does anyone
else have any experience with this or any ideas as to how to go about fixing
it? Thanks very much.</span></font><font color="black" face="Times"><span style="color: black; font-family: Times; "></span></font></div>
</div>
<div>
<div class="yiv1163934639MsoNormal" style="background:white;"><font size="3" color="black" face="Times New Roman"><span style="font-size:12.0pt;color:black;"> </span></font><font color="black" face="Times"><span style="color: black; font-family: Times; "></span></font></div>
</div>
<div>
<div class="yiv1163934639MsoNormal" style="background:white;"><font size="3" color="black" face="Times New Roman"><span style="font-size:12.0pt;color:black;">Gregory</span></font><font color="black" face="Times"><span style="color: black; font-family: Times; "></span></font></div>
</div>
<div>
<div class="yiv1163934639MsoNormal" style="background:white;"><font size="3" color="black" face="Times New Roman"><span style="font-size:12.0pt;color:black;"> </span></font><font color="black" face="Times"><span style="color: black; font-family: Times; "></span></font></div>
</div>
</div>
</div>
<div class="yiv1163934639MsoNormal" style="margin-bottom:12.0pt;background:white;"><font size="3" color="black" face="Times"><span style="font-size: 12pt; color: black; font-family: Times; "><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>
</span></font></div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
<div class="yiv1163934639MsoNormal" style="margin-bottom:12.0pt;"><font size="3" color="black" face="Times New Roman"><span style="font-size:12.0pt;color:black;"><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>
</span></font></div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div><br><br></div></div></blockquote></div></div></body></html>