Never been to CodeSnippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)

2 total

On This Page:

  1. 1 Automatic Pagination
  2. 2 Limit equivelent for MSSQL

Automatic Pagination

to pagination cakephp by yitzc on Jun 03, 2008
// description of your code here
Automatic Pagination:
(using model bankBranches with fields 'name' and 'bank_id')
var $paginate = array('order' =>array('name' => 'asc')); //paginate by name

OR

$this->set('bankBranches', $this->paginate('BankBranch.bank_id')); //paginate by bank_id


Sometimes one works, and sometimes the other one works...

Limit equivelent for MSSQL

to mysql sql mssql limit clause paging pagination paginating offset limitting by chrelad on Oct 12, 2007
Props to this site for the answer:

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=850&lngWId=5
// MySQL limit clause
SELECT emp_id,lname,fname FROM employee LIMIT 20,10

// MSSQL equivelent
select * from (
 select top 10 emp_id,lname,fname from (
    select top 30 emp_id,lname,fname
    from employee
   order by lname asc
 ) as newtbl order by lname desc
) as newtbl2 order by lname asc

"The main thing to remember is to deal with all your ORDER BY clauses and also to use the inner TOP as the sum of what you are looking for. In this example - 30 since you start at 20 and want 10 rows (20+10=30)."
_
2 total

On This Page:

  1. 1 Automatic Pagination
  2. 2 Limit equivelent for MSSQL