[postgis] php update

[Petri J. Riipinen]

Hello,

My feeble attempt as a PostGIS newbie:

Shouldn't that be: $sql="insert into roads values ('$id','$desc', 
GeometryFromText('LINESTRING ($points)'), SRID)";

where SRID is e.g. -1.

- Petri

At 15:47 6.11.2001 , you wrote:
>hello,
>
>I have created a php script witch update a table roads. In that table
>roads i have a LINESTRING field "points"
>
>the script works like this:
>
>$sql="insert into roads values ('$id','$desc', 'LINESTRING
>($points)')";
>
>but the LINESTING insn't working...
>
>Can i update the table like this?
>
>Thanks
>João.

<><><><><><><><>
   Petri J. Riipinen
petri.riipinen at nic.fi
<><><><><><><><>

To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/