CodeIgniter Forums - Search Results

Search Results

Thread: Error with complex Oracle query
Post: RE: Error with complex Oracle query

Kaosweaver Wrote: (08-17-2017, 05:23 AM) -- You have a WHERE clause outside of the subquery in your SELECT declaration. I color coded it for you and explained that your footer code ADDs a new WHERE ...

Thread: Error with complex Oracle query
Post: RE: Error with complex Oracle query

Kaosweaver Wrote: (08-16-2017, 06:06 AM) -- $this->db->select("pu.username, pu.last_name, pu.first_name, pu.middle_name, ppi.passport_number, ps.passport_status_des...

Thread: Error with complex Oracle query
Post: RE: Error with complex Oracle query

Kaosweaver Wrote: (08-15-2017, 05:04 AM) -- In blue in your post is a $this->db->select() where you have a FROM and WHERE Then you have a $this->db->where() which appends the SELECT with "WHERE..." ...

Thread: Error with complex Oracle query
Post: RE: Error with complex Oracle query

Kaosweaver Wrote: (08-09-2017, 10:49 AM) -- Code: -- $this->db->select("select pu.last_name, -- Remove the select, this should just be column names. Code: -- $this->db->select("pu.last_name, -...

Thread: Error with complex Oracle query
Post: RE: Error with complex Oracle query

pporlan Wrote: (08-08-2017, 03:40 AM) -- Maybe CI is escaping something it doesn't need to, like this: PHP Code: -- $this->db->from("passport_users, (select pi.username, ...

Thread: Error with complex Oracle query
Post: RE: Error with complex Oracle query

Kaosweaver Wrote: (08-07-2017, 05:52 AM) -- The error you're getting (ORA-00936c) is referenced here: http://www.dba-oracle.com/sf_ora_00936_missing_expression.htm to show that something is wrong w...

Thread: Error with complex Oracle query
Post: RE: Error with complex Oracle query

Kaosweaver Wrote: (08-04-2017, 05:07 AM) -- I'm not certain how Oracle does alias names, however, I do not see anything for the alias "pu" in the list of tables in the FROM declaration. I would assum...

Thread: Error with complex Oracle query
Post: RE: Error with complex Oracle query

Thanks for the reply. You are absolutely correct; however, after adding in the alias I still get the error. I get this whether I use a query string or Active Record. I believe the problem is in me usi...

Thread: Error with complex Oracle query
Post: Error with complex Oracle query

I’m getting this error when trying an Oracle query inside a search function: Code: -- A PHP Error was encountered Severity: Warning Message: oci_execute(): ORA-00936: missing expression ...