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

(09-23-2019, 11:40 AM)jreklund Wrote: Just by the looks of it, try this:
Code:
$this->db->select('COUNT(*) AS FOUND', false);

https://codeigniter.com/user_guide/datab...er::select

And what is $where in this context?

Should be:
Code:
$this->db->like('ul_datetime_login', '23-09-2019', 'after');

Complete code, as ->get() looked wrong too.
Code:
$this->db->select('COUNT(*) AS FOUND', false);
$this->db->like('ul_datetime_login', '23-09-2019', 'after');
$row = $this->db->get('ci_r_user_log')->row();

I try with FALSE but the result is still. The $where is an array contains :
PHP Code:
$where['"ul_datetime_login" LIKE \''.$date.'%\''] = NULL

I used that code because i've try with LIKE and the result is still zero.

->get() code, i follow in the query builder class. I've used for mySQL and postgreSQL DB and it looks fine. But now when i use oracle DB, it doesnt work.
Reply


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



Theme © iAndrew 2016 - Forum software by © MyBB