Help with Spatial Extension
Hello,
I am having problems getting geometry into my DB table. I am using XAMPP which uses MySQL 5.0. I built my table with a column of type "geometry". I have been able to manually enter a point, but when I try and enter another, different point, it gives me an error regarding "duplicate geometry".
I'm also having issues inserting data through my php scripts. Below is one of the queries I am using:
$insert_statement = "INSERT INTO `order`(geom) VALUES (GeomFromText(POLYGON('$wkt_poly')))";
Where $wkt_poly = (39.75326104990142 -104.97015953063965 , 39.74930171012357 -104.95805740356445 , 39.74633205595244 -104.96458053588867 , 39.74633205595244 -104.96458053588867 , 39.75326104990142 -104.97015953063965)
Thoughts?
Also, anyone know if it's possible to access mysql command line with xampp??
Thanks!
Edited 1 time(s). Last edit at 04/17/2007 08:20PM by Peter Battaglia.
Subject
Views
Written By
Posted
Help with Spatial Extension
4529
April 17, 2007 08:19PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.