[eluser]Unknown[/eluser]
Hello Sir,
As i check the code of codeigniter related with paging that i connect with sqlsrv it seem doesn't work.
function _limit($sql, $limit, $offset)
{
$i = $limit + $offset;
return preg_replace('/(^\SELECT (DISTINCT)?)/i','\\1 TOP '.$i.' ',$sql);
}
I checked it already it just select top from table not do as paging