is there any way to pass mysql's NOW() to mysql ?

[eluser]gtech[/eluser]
when you pass your params through the insert function all the quotes have slashes added to them as the set() function is called within the insert() function with escape set to TRUE.

it would be the same as doing:

Code:

//Data
$data = array(
    'ID' => '',
    'Hash' => $params['file_name']
);  
//use true instead and value will be inserted as \'NOW()\' meaning 'NOW()' will be inserted into the database.
$this->db->set('DateUploaded', 'NOW()',TRUE);
$this->db->set($data);

$this->db->insert('Photos');

thats why it wont work, active record is built to escape strings as default.