Welcome Guest, Not a member yet? Register   Sign In
Active Record - Can it do it..?
#11

[eluser]rvent[/eluser]
Thanks mattpointblank, your method worked..

Code:
function updateDataLike($table, $sn, $seq, $data)
    {
        $this->db->where('sequence_name_id', $seq);
        $this->db->where('serial_number LIKE "'.$sn.'%"');
        return $this->db->update($table, $data);
    }
#12

[eluser]Colin Williams[/eluser]
You should file a bug report on this if you're sure it's a repeatable problem.
#13

[eluser]rvent[/eluser]
I dont know if it's a bug or not, it depends on whether or not it was intended to be used as i used it:

DOESNT WORK:
Code:
function updateDataLike($table, $sn, $seq, $data)
    {
        $this->db->where('sequence_name_id', $seq);
        $this->db->like('serial_number', $sn, 'after');
        return $this->db->update($table, $data);
    }
$this->db->last_query():
Code:
UPDATE `dlog_sequence_log` SET `priority` = 'HIGH', `assembler_id` = '101' WHERE `sequence_name_id` = '9'


IT WORKS:
Code:
function updateDataLike($table, $sn, $seq, $data)
    {
        $this->db->where('sequence_name_id', $seq);
        $this->db->where('serial_number LIKE "'.$sn.'%"');
        return $this->db->update($table, $data);
    }

$this->db->last_query():
Code:
UPDATE `dlog_sequence_log` SET `bake` = 'NO', `assembler_id` = '102' WHERE `sequence_name_id` = '9' AND `serial_number` LIKE "99111%"



So i guess it all depends on whether or not was intended to do that...

Thanks for all the help.




Theme © iAndrew 2016 - Forum software by © MyBB