Hi there! Is there any reason you don't want to just use CF to handle all the pagination? Here's a good example...
http://tutorial405.easycfm.com/ Mike On Thu, Jun 18, 2009 at 10:18 AM, Erich93063 <erich93...@gmail.com> wrote: > > 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. >
