... or http://paginationcfc.riaforge.org/
On Thu, Jun 18, 2009 at 10:31 AM, Michael Ennis <mik...@pttracker.com>wrote: > 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. >> > > -- I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of success.
