<html>
<head>
<title></title>
<meta content="MSHTML 6.00.2900.5764" name="GENERATOR"></meta>
</head>
<body>
<div>Hi</div>
<div> </div>
<div>you have to input a string to geomtfromtext</div>
<div> </div>
<div>like this:</div>
<div> </div>
<div>GeomFromText('MULTIPOLYGON(((-119.2 33.46, -118.7 333.46, -118.7 32.66, -119.2 33.66, -119.2 33.46))) ')<br />
</div>
<div>/Nicklas Avén</div>
<div><br />
2009-04-24 Malm Paul wrote:<br />
<br />
></div>
<div align="left">
<span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hi,</span></div>>
<div align="left">
<span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I´m trying this:</span></div>>
<div align="left">
<span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">SELECT submapid, mapid, blob, AsText(the_geom) as the_geom </span></div>>
<div align="left">
<span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">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></div>>
<div align="left">
<span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I´ve also tried this:</span></div>>
<div align="left">
<span style="FONT-SIZE: 10pt; COLOR: #0000ff; FONT-FAMILY: Arial"></span>>
<div align="left">
<span style="FONT-SIZE: 10pt; COLOR: #000000; FONT-FAMILY: Arial">SELECT submapid, mapid, blob, AsText(the_geom) as the_geom </span></div>>
<div align="left">
<span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">
<span style="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))) )</span> </span></div>>
<div align="left">
<span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> </span></div></div>>
<div align="left">
<span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></span>>
<div>
<span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">But all I'm getting is this:</span></div></div>
<span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></span>>
<div align="left">
<span style="COLOR: #0000ff"></span><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</div>>
<div>
<span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> </span></div>>
<div>
<span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> </span></div>>
<div>
<span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I would be happy if someone could tell me what I´m doing wrong?</span></div>>
<div>
<span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> </span></div>>
<div>
<span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Kind regards,</span></div>>
<div>
<span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Paul</span><br />
></div>>
<div>
<span style="FONT-SIZE: 10pt; COLOR: #0000ff; FONT-FAMILY: Arial"> </span></div>
</body>
</html>