Active record and NULL value ?

[eluser]ariok[/eluser]
Hi all,
I found this problem working with active record:
What i have to do if i need to insert a NULL value in my DB ?

if i have array data with:
"fieldone"=>"this value",
"fieldtwo"=>null

the query generated with $this->db->insert($array)... is something like:

Code:

(fieldone,fieldtwo) values ("this value",[b]"null"[/b])

But i want a query like

Code:

(fieldone,fieldtwo) values ("this value",[b]null[/b])

with null and not "null"....

there's a pratical way to obtain the second query instead first?

Thank you all ..

Ariok

[eluser]easymind[/eluser]
I don't think so. I had the same problem with TIMESTAMP=NOW(). I don't want "NOW()". So I just use normal queries and no active record for these. Like $this->db->query('INSERT INTO thingy SET yours=null and mine=NOW()');

It is a damn shame But I am guessing it is also hard to fix without using an alternative way to syntax the variables you send to the active record class.

By the way, did you try:
'fieldtwo'=>''
or
'fieldtwo'=>false?

I think it should save the default value for that column in your mysql table and that probably is set to NULL?

[eluser]ariok[/eluser]
ops... i wrong something
I have to say that i i use this array

"fieldone"=>"this value",
"fieldtwo"=>null

I obtain:

(fieldone,fieldtwo) values ("this value",null) without ""

So it's all ok ....sorry.