OK so I've been searching for a week now for an example of pagination of data using jquery, ColdFusion and SQL server. I'm finding tons of examples using PHP and MySQL. Have any of you successfully got pagination working with Fusion and SQL Server? I am trying to run a report that could end up having thousands of results that I would like to paginate using jquery. Most of the pagination plugins though rely on you returning ALL of the results to the client first whether in JSON, XML or just straight to the browser as a table and then it paginates them. So if there are thousands of results this is not optimal. I'd like to try and get something working where as it paginates it goes to the database using Fusion and just grabs the next X records to display.
I came across this article: http://blog.pengoworks.com/index.cfm/2006/6/19/MSSQL-2k-Stored-Procedure-for-Pagination Which is a SQL stored proc that will get the next X records but it only works on one flat table. My report query will be joining multiple tables. So basically here's what I'm looking for: jquery pagination can handle thousands of records uses ColdFusion to generate the recordset (JSON, XML, whatever) uses SQL Server only retrieves the records that are needed on the current page If anyone has seen any examples, tutorials etc that would be awesome. Thanks.
