--_e2469974-0d4c-40d7-aff7-13db7ae5406d_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I'm trying upate a group of records. In the table I have 1 field geometry
a=
nd 2 fields ineteger with long. and lat. everyone. I try to update the
fiel=
d geometry with point(long lat).
=20
I use this update with numbers and this is ok.UPDATE public."Contenedor"
SE=
T ubicacion =3D GeomFromText('POINT(1.9845 49.8543)', 4326) but when i
chan=
ge the number by a field this is not ok. : UPDATE public."Contenedor" SET
u=
bicacion =3D GeomFromText('POINT(public.Contenedor.long 49.8543)', 4326)
I=
have this error.
ERROR: parse error - invalid geometry Estado SQL:XX000 Contexto:SQL
functio=
n "geomfromtext" statement 1 Everyone can tell ma some solution please.
=20
Thank you.
=20
=20
_________________________________________________________________
Discover the new Windows Vista
http://search.msn.com/results.aspx?q=3Dwindows+vista&mkt=3Den-US&form=3DQBR=
E=
--_e2469974-0d4c-40d7-aff7-13db7ae5406d_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<html>
<head>
<style>
..hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class=3D'hmmessage'>
I'm trying upate a group of records. In the table I have 1 field
=
geometry and 2 fields ineteger with long. and lat. everyone. I try to
updat=
e the field geometry with point(long lat).<BR>
<BR>
I use this update with numbers and this is ok.<BR><BR>UPDATE
<BR>public."Co=
ntenedor" <BR>SET <BR>ubicacion =3D GeomFromText('POINT(1.9845 49.8543)',
4=
326) <BR><BR>but when i change the number by a field this is not ok. :
<BR>=
<BR>UPDATE <BR>public."Contenedor" <BR>SET <BR>ubicacion =3D
GeomFromText('=
POINT(public.Contenedor.long 49.8543)', 4326) <BR> <BR><BR>I have
this=
error.<BR>
<BR>ERROR: parse error - invalid geometry <BR>Estado SQL:XX000
<BR>Contexto=
:SQL function "geomfromtext" statement 1 <BR><BR>Everyone can tell ma some
=
solution please.<BR>
<BR>
Thank you.<BR>
<BR>
<BR>
<!-- google_ad_section_end --><!-- google_ad_section_end --><BR><br /><hr
/=
>Discover the new Windows Vista <a
href=3D'http://search.msn.com/results.as=
px?q=3Dwindows+vista&mkt=3Den-US&form=3DQBRE' target=3D'_new'>Learn
more!</=
a></body>
</html>=
--_e2469974-0d4c-40d7-aff7-13db7ae5406d_--
