Can someone please explain to me with sample code on how to properly structure my MVC app? What I want to do is have a grid with a paging toolbar. I want the grid to load 10 records per page. I have setup my ColdFusion server side processing with two SQL statements:
- Query that gets total record count
- Query that utilizes the LIMIT arguments set
start
andlimit
respectively.
I find loads of forum questions with local data but my data is on a remote server.