You can do something similar with SQL Server 2005 http://www.stillnetstudios.com/2008/11/12/pagination-mssql-2005/
-Ryan Andy Matthews wrote: > If you're using mySQL, then look into the LIMIT keyword: > > SELECT [columns] > FROM [tableName] > LIMIT [totalRecords], [startingRow] > > This way you ONLY get the data you want. You could easily tie this into a > data grid via Ext (or jQuery) so that new pages call only the data for that > page. > > Here's one of the preeminent jQuery versions: http://www.flexigrid.info/ > > And a tutorial written by a coworker of mine on Ext data grids: > http://blog.cutterscrossing.com/index.cfm/2007/4/24/My-First-ExtJS-DataGrid- > Pt-1 > > > andy > > -----Original Message----- > From: Chad Gray [mailto:cg...@careyweb.com] > Sent: Thursday, June 04, 2009 10:07 AM > To: cf-talk > Subject: reducing a query result > > > Say I have a query returned with 500 records. > > Is there a way in CF (not SQL) to reduce the query to only rows 1-50, 51-100 > etc? > > I talking physically reducing the query object. > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323176 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
