Welcome Guest, Not a member yet? Register   Sign In
[3.1.5] Update Batch and Where Problems
#1

(This post was last modified: 07-27-2017, 06:08 PM by rodrigoprazim.)

Hi,

I have the following Scenario:
Code:
public function update_data($data=NULL){
     $this->db->where('status','1');
     $this->db->update_batch('tb_fone',$data,'user_id');
}

I have over 100 data to be updated, so, the top 100 look like this:
Code:
// Produces: 
// UPDATE `tb_fone` SET `name` = CASE
// WHEN `column` = 'My title' THEN 'My Name 2'
// WHEN `column` = 'Another title' THEN 'Another Name 2'
// ELSE `name` END,
// `date` = CASE 
// WHEN `title` = 'My title' THEN 'My date 2'
// WHEN `title` = 'Another title' THEN 'Another date 2'
// ELSE `date` END
// WHERE `title` IN ('My title','Another title')
// AND `status` = '1';

However, the next data is missing WHERE:
Code:
// Produces: 
// UPDATE `tb_fone` SET `name` = CASE
// WHEN `column` = 'My title' THEN 'My Name 2'
// WHEN `column` = 'Another title' THEN 'Another Name 2'
// ELSE `name` END,
// `date` = CASE 
// WHEN `title` = 'My title' THEN 'My date 2'
// WHEN `title` = 'Another title' THEN 'Another date 2'
// ELSE `date` END
// WHERE `title` IN ('My title','Another title');
Reply


Messages In This Thread
[3.1.5] Update Batch and Where Problems - by rodrigoprazim - 07-27-2017, 06:08 PM



Theme © iAndrew 2016 - Forum software by © MyBB