Welcome Guest, Not a member yet? Register   Sign In
Oracle filter with LIKE method always zero result
#1

Hi, Im working with CI and oracle right now but i have difficulties if i use LIKE method.

My code like this :
Code:
$this->db->select('COUNT(*) AS FOUND');
        $this->db->where($where);
        $row = $this->db->get('"ci_r_user_log"')->row();
 And the result is zero for FOUND

I try to look the query and the result like :
Code:
SELECT COUNT(*) AS FOUND FROM "ci_r_user_log" WHERE "ul_datetime_login" LIKE '23-09-2019%'

I try run the query with SQL Developer and get 4 data found. I checked and it's correct.

So why the query that run with CI is not working? But the query is good

Im sorry if my english is bad.
Reply


Messages In This Thread
Oracle filter with LIKE method always zero result - by fauzi26 - 09-22-2019, 09:30 PM



Theme © iAndrew 2016 - Forum software by © MyBB