Active record 'update' introducing 0 into previously null columns

[eluser]richzilla[/eluser]
Hi All,

Is there anyway to view the SQL that active record produces as im having a bit of a problem with the update function. Basically, whenever the update function is run, two zero's appear in my table in fields that were previously null. The form fields are also null. Does anyone know why this might be happening?

Any help would be appreciated,
Thanks

[eluser]n0xie[/eluser]

Code:

echo $this->db->last_query();

Or turn on profiler

[eluser]danmontgomery[/eluser]
I'm guessing that you're just setting the value without checking it:

Code:

$this->db->set('some_field', $this->input->post('some_field'));

Which will return FALSE, or 0 for form fields which are left blank (I'm assuming this is what you mean by null). To solve this you just need to check the value of the field before you set it.

Code:

if($this->input->post('some_field') != FALSE) {
    $this->db->set('some_field', $this->input->post('some_field'));
}