<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>correcting polygons</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.3527" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial size=2><SPAN
class=401212610-24042009>Hi,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial size=2><SPAN
class=401212610-24042009>I´m trying this:</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial size=2><SPAN
class=401212610-24042009>SELECT submapid, mapid, blob, AsText(the_geom) as
the_geom </SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial size=2><SPAN
class=401212610-24042009>FROM submap WHERE <BR>the_geom &&
GeomFromText(’MULTIPOLYGON(((-119.2 33.46, -118.7 333.46, -118.7 32.66, -119.2
33.66, -119.2 33.46)))’ ) <BR></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial size=2><SPAN
class=401212610-24042009>I´ve also tried this:</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial size=2><SPAN
class=401212610-24042009><FONT color=#0000ff>
<DIV dir=ltr align=left><FONT face=Arial color=#000000 size=2><SPAN
class=401212610-24042009>SELECT submapid, mapid, blob, AsText(the_geom) as
the_geom </SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial size=2><SPAN
class=401212610-24042009><FONT color=#000000>FROM submap WHERE <BR>the_geom
&& GeomFromText(’MULTIPOLYGON(((-119.2 33.46, -118.7 333.46, -118.7
32.66, -119.2 33.66)))’ )</FONT> </SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial size=2><SPAN
class=401212610-24042009></SPAN></FONT> </DIV></FONT></DIV></SPAN></FONT>
<DIV dir=ltr align=left><FONT face=Arial size=2><SPAN class=401212610-24042009>
<DIV></SPAN></FONT><FONT face=Arial size=2><SPAN class=401212610-24042009>But
all I'm getting is this:</SPAN></FONT></DIV></DIV><FONT face=Arial size=2><SPAN
class=401212610-24042009>
<DIV dir=ltr align=left><FONT color=#0000ff></FONT><BR>ERROR: syntax error
at or near "33.46"<BR>RAD 2: the_geom &&
GeomFromText(’MULTIPOLYGON(((-119.2 33.46,
-118....<BR>
^</DIV>
<DIV>********** Error **********</DIV>
<DIV>ERROR: syntax error at or near "33.46"<BR>SQL state: 42601<BR>Character:
127</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=401212610-24042009><FONT face=Arial
size=2>I would be happy if someone could tell me what I´m doing
wrong?</FONT></SPAN></FONT></DIV>
<DIV><SPAN class=401212610-24042009><FONT face=Arial
size=2> </FONT></SPAN></DIV>
<DIV><!-- Converted from text/rtf format --><SPAN
class=401212610-24042009></SPAN><FONT face=Arial><FONT
size=2>Kind regards,</FONT></FONT></DIV>
<DIV><SPAN class=401212610-24042009></SPAN><SPAN
class=401212610-24042009></SPAN><FONT face=Arial><FONT size=2>P<SPAN
class=401212610-24042009>aul</SPAN></FONT></FONT><BR></DIV>
<DIV><SPAN class=401212610-24042009><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV></BODY></HTML>