Error with Join and Active Record - 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: Error with Join and Active Record (/showthread.php?tid=48299) |
Error with Join and Active Record - El Forum - 01-11-2012 [eluser]Unknown[/eluser] Hello I’m trying to follow documentation for creating a join (http://ellislab.com/codeigniter/user-guide/database/active_record.html) The doc says : Code: $this->db->select('*'); Code: $this->db->select('marker_id, marker_name, taxon.scientific_name, marker.group_id', FALSE); Quote:Error Number: You can see this post : http://ellislab.com/forums/viewthread/207389/ Even with a really simple query : Code: $this->db->select('marker_id, marker_name, group_id', FALSE); Quote:Error Number: I need help or some explanations. The escape rules for lazy seem to prevent me to build a correct query ! I should miss something, and I need your help Thank you. (Oracle database 11.2.0.1.0, CI 2.1.0) Fred Error with Join and Active Record - El Forum - 01-27-2012 [eluser]Unknown[/eluser] Hello Code: $this->db->select('marker_id, marker_name, taxon.scientific_name, marker.group_id', FALSE); it does not work : Quote:Error Number: Look at the where clause : taxon and taxon_id are enclosed by ", marker is not ! Does somebody else use CodeIgniter with an Oracle database ? Fred |