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:323175 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
