Welcome Guest, Not a member yet? Register   Sign In
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 ...
114,244 Views
18 Replies
08-17-2017, 02:30 PM
jace
    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...
114,244 Views
18 Replies
08-16-2017, 11:36 PM
jace
    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..." ...
114,244 Views
18 Replies
08-15-2017, 12:01 PM
jace
    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, -...
114,244 Views
18 Replies
08-15-2017, 12:14 AM
jace
    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,                 ...
114,244 Views
18 Replies
08-08-2017, 07:44 PM
jace
    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...
114,244 Views
18 Replies
08-07-2017, 09:29 PM
jace
    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...
114,244 Views
18 Replies
08-05-2017, 09:59 AM
jace
    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...
114,244 Views
18 Replies
08-05-2017, 09:36 AM
jace
    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 ...
114,244 Views
18 Replies
08-03-2017, 05:33 PM
jace

Theme © iAndrew 2016 - Forum software by © MyBB