<div dir="ltr"><div>Well it looks ok, but it's not pure SQL.<br></div>You should just test it.<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Sat, Jan 12, 2013 at 3:10 PM, Jeff Lake <span dir="ltr"><<a href="mailto:jeff@michiganwxsystem.com" target="_blank">jeff@michiganwxsystem.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<div>No error yet,<br>
Just wondering if that is correct ??<div class="im"><br>
<br>
<br>
<div><b>Jeff Lake</b><br>
<a href="http://www.michiganwxsystem.com" target="_blank">MichiganWxSystem</a><br>
<a href="http://www.allisonhouse.com" target="_blank">AllisonHouse</a><br>
<a href="http://www.grlevelxstuff.com" target="_blank">GRLevelXStuff</a></div></div><div><div class="h5">
On 1/12/2013 6:12, Willy-Bas Loos wrote:<br>
</div></div></div><div><div class="h5">
<blockquote type="cite">
<div dir="ltr">what's the error message?<br>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Fri, Jan 11, 2013 at 10:09 PM, Jeff
Lake <span dir="ltr"><<a href="mailto:jeff@michiganwxsystem.com" target="_blank">jeff@michiganwxsystem.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF"> I have an already
established table..<br>
using a php script to run periodic updates to the GIS data<br>
I have seen all kinds of INSERT and SELECT unless I'm
missing it no UPDATE ??<br>
would the following work??<br>
$polygon is Latitude Longitude pairings <br>
<br>
"UPDATE conv SET geom =
ST_GeomFromText('LINESTRING(".$polygon.")', -1) WHERE
wwnum = '".$wnum."'"<span><font color="#888888"><br>
<div>-- <br>
<b>Jeff Lake</b><br>
<a href="http://www.michiganwxsystem.com" target="_blank">MichiganWxSystem</a><br>
<a href="http://www.allisonhouse.com" target="_blank">AllisonHouse</a><br>
<a href="http://www.grlevelxstuff.com" target="_blank">GRLevelXStuff</a></div>
</font></span></div>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
<br>
</blockquote>
</div>
<br>
<br clear="all">
<br>
-- <br>
"Quality comes from focus and clarity of purpose" -- Mark
Shuttleworth<br>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
postgis-users mailing list
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<br>
</div></div></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth<br>
</div>