[SOLVED]database error occurred

[eluser]pistolPete[/eluser]
Try some debugging:

Code:

function getTypes($datacode)
{            
        $this->db->select('data_id,data_value,data_display,description');
        $this->db->where('data_code', $datacode);
        $this->db->where('display',1);
        $this->db->orderby("order_idx", "asc");
        $query = $this->db->get_where('sec_dataset');
        die('<pre>'.print_r($query,TRUE).'</pre>');
        return $query->result();        
}

What output do you get?

How do you process the query result in your controller / view?