Ok, I feel like this should be something simple but my brain just isn't working this morning. Besides using CFOUTPUT with the startrow and maxrows attributes, is there a way in my SQL itself to specify that I want it to grab 50 rows starting at the 200th row. I'm trying to make a paged approach to a query that could potentially have about 20,000 records returned. I'd much rather just have MS SQL return 50 rows at a time by telling it which row to start at rather than having it return a 20,000 recordset to CF and then only output 50. I'm hoping this is something easy and my brain just hasn't woken up yet. Any thoughts would be appreciated. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219406 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
