我试图从SQL服务器执行CodeIgniter中的过程，我做错了什么？

Question

I am trying to execute the stored procedure from my SQL server database and make it print a list, what is the best way to print it out?

This is my Model:

class Categories_Model extends CI_Model
{
public function __construct()
{
    parent::__construct();
}

function get_categories()
{
    $sql = 'exec spGetCategoriesByID';
    $query = $this->db->query($sql);
    $result = $query->result();
    return $result;
}
}

This is my Controller:

class Categories_Controller extends CI_Controller
{
public function __construct()
{
    parent::__construct();
    $this->load->helper('url');
    $this->load->database();
}

public function categories_list()
{
    $this->load->model('Categories_Model');
    $cat_result = $this->Categories_Model->get_categories();
    $data['catlist'] = $cat_result;
    $this->load->view('categories',$data);
}
}

Answer 1

Try getting the error like this:

$query = $this->db->query($sql);
echo 'Error #'.$this->db->_error_number().': '.$this->db->_error_message();
die();