Welcome Guest, Not a member yet? Register   Sign In
paging with sqlsrv
#1

[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





Theme © iAndrew 2016 - Forum software by © MyBB