MSSQL Pagination Holly Grial?

[eluser]gusa[/eluser]
[quote author="whobutsb" date="1228863348"]
$this->db->select('contactID, firstname, lastname');
$this->db->limit($offset, $limit);
$query = $this->db->get('tblContact');
[/quote]

try specifying the form clause, like this:

Code:

$this->db->select('contactID, firstname, lastname');
$this->db->from('tblContact');
$this->db->limit($offset, $limit);
$query = $this->db->get();

My code looks like what you've written.