Oracle query problem - 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: Oracle query problem (/showthread.php?tid=3530) |
Oracle query problem - El Forum - 10-08-2007 [eluser]Unknown[/eluser] Hello, I've download version 1.5.4 and am having some problems executing Oracle queries. I have Apache 2.2 and Oracle 10g (including the instantclient_10_2 directory and proper pathing) all local on a Vista machine. Note that I am able to use oci_connect and run a query that way but I would really like to use the built in functionality of the framework. Note my connection to the database works using load->database, it's when it hits the query I get an error. I'm sure I just have something configured wrong but being new to PHP and frameworks I'm stumped. Here are are my DB settings: $active_group = "default"; $db['default']['hostname'] = "//localhost/XE"; $db['default']['username'] = "dev"; $db['default']['password'] = "dev"; $db['default']['database'] = ""; $db['default']['dbdriver'] = "oci8"; $db['default']['dbprefix'] = ""; $db['default']['active_r'] = TRUE; $db['default']['pconnect'] = TRUE; $db['default']['db_debug'] = TRUE; $db['default']['cache_on'] = FALSE; $db['default']['cachedir'] = ""; Here is my simple PHP code: $this->load->database(); $query = $this->db->query("select 1 from dual"); This is the error I get (line 69 is the $query = ...) A PHP Error was encountered Severity: Notice Message: Undefined property: CI_Loader::$db Filename: views/welcome_message.php Line Number: 69 Thanks in advance for any help. Mike |