Can´t select data PDO with CI 2.2.1 |
[UPDATE]
Does not mater if it is a JOIN. I can´t get data period. So this does not work: $this->db->get('objects'); This will return nothing. However this will work: $data = array( 'moName' => 'something' ); $this->db->insert('objects', $data); So there should not be anything about file/directory rights. [/UPDATE] So i had this problem (CI 2.2.0): http://forum.codeigniter.com/thread-6130...#pid315991 I upgraded to CI 2.2.1 and now i can´t fetch JOIN data...wonderful! Tried the generated SQL string directly in my SQLLite DB and it will fetch at least 4 posts. But when i run it using CI...nothing will get back. I skimmed the change log and it should not behave like this: PHP Code: $this->db->select("*"); This will generate the SQL string that will WORK when executed in the SQLLite db.: SELECT * FROM objects JOIN objects_data ON objects.moId = objects_data.modObject JOIN component_types ON objects.moComponenttype = component_types.mctId WHERE objects.moType = 'page' |
Messages In This Thread |
Can´t select data PDO with CI 2.2.1 - by Jacker - 04-08-2015, 04:58 AM
RE: Can´t get JOIN data using PDO with CI 2.2.1 - by Avenirer - 04-08-2015, 05:19 AM
RE: Can´t get JOIN data using PDO with CI 2.2.1 - by Jacker - 04-08-2015, 05:36 AM
RE: Can´t select data PDO with CI 2.2.1 - by mwhitney - 04-13-2015, 08:59 AM
RE: Can´t select data PDO with CI 2.2.1 - by Jacker - 04-13-2015, 10:50 PM
RE: Can´t get JOIN data using PDO with CI 2.2.1 - by Avenirer - 04-08-2015, 05:47 AM
RE: Can´t get JOIN data using PDO with CI 2.2.1 - by Jacker - 04-08-2015, 05:51 AM
|