Welcome Guest, Not a member yet? Register   Sign In
DMZ upload

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?

$this->ad_id = $ad;
$this->timeslot = 'LINESTRING(POINT(' . $terminal . ',' . $start_unix . '),POINT(' . $terminal . ',' . ($start_unix + $duration) . '))';

I figured it out.

Theme © iAndrew 2016 - Forum software by © MyBB