CodeIgniter Forums
DMZ upload - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: DMZ upload (/showthread.php?tid=33552)



DMZ upload - El Forum - 08-30-2010

[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();



DMZ upload - El Forum - 08-31-2010

[eluser]frist44[/eluser]
I figured it out.