[ASK] Query Data using Oracle. Working on Navicat, doesn't work on CodeIgniter - 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: [ASK] Query Data using Oracle. Working on Navicat, doesn't work on CodeIgniter (/showthread.php?tid=60181) |
[ASK] Query Data using Oracle. Working on Navicat, doesn't work on CodeIgniter - El Forum - 02-01-2014 [eluser]Unknown[/eluser] Hi.. I have a problem with CodeIgniter when I select multiple table using $this->db->query(); First, I made the query using Navicat for Oracle, and it works. But when I put the query into $this->db->query(); I got an error like I got in the second picture. workin' on Navicat <img src="https://fbcdn-sphotos-f-a.akamaihd.net/hphotos-ak-prn2/t1/q71/1560665_257629487737027_445594976_n.jpg"> doesn't work on CodeIgniter <img src="https://fbcdn-sphotos-h-a.akamaihd.net/hphotos-ak-prn1/t1/q71/s720x720/1551617_257629501070359_831779571_n.jpg"> So, I tried to modify the query into selecting only a single table. And, BOOM! It works. So I though the problem is in the way I join the table. But let's see, I got the query works in Navicat. and I change into selecting only a single table, it works -_- <img src="https://fbcdn-sphotos-b-a.akamaihd.net/hphotos-ak-ash3/t1/q71/s720x720/1010781_257629507737025_702287803_n.jpg"> Does anyone ever had the same problem? Thank you so much. |