[eluser]James Bolongan[/eluser]
Based on our project, there is no problem about on the
Active Record Class of the CI.
Actually, you have the option to use either to use the active record class or just do a simple query.
example1:using active record class
Code:
$where = "where A.id = B.id";
$this->db->where($where);
$this->db->orderby('A.id');
$this->db->get('A,B'');
example2
simple query)
Code:
$this->db->query("select * from A,B where A.id = B.id order by A.id asc");
Best on my experience, I already connect to a database like Interbase, Oracle, Postgrey, MSSQL, MYSQL using the CI.
And most of the libraries of CI really works and theres is no problem I enountered.