Well I was hoping to stay on the same page and have jquery sorting. But I love that CFC at riaforge. That's awesome. I may just use that.
On Jun 18, 10:34 am, Charlie Griefer <charlie.grie...@gmail.com> wrote: > ... orhttp://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-Proced... > > >> 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.
