[eluser]frist44[/eluser]
I'm trying to insert a record with a LINESTRING type and I get this:
A Database Error Occurred
Error Number: 1416
Cannot get geometry object from data you send to the GEOMETRY field
INSERT INTO `instances` (`ad_id`, `timeslot`, `created`) VALUES (1, 'LINESTRING(POINT(1,1283214960),POINT(1,1283214970))', '2010-08-31 00:36:00 +0000')
I noticed if i remove the single quote from the LINESTRING portion, everything works good for the insert in my DBMS. However, how can I simulate that in DMZ?
Code:
$this->ad_id = $ad;
$this->timeslot = 'LINESTRING(POINT(' . $terminal . ',' . $start_unix . '),POINT(' . $terminal . ',' . ($start_unix + $duration) . '))';
$this->save();
