really easy in mysql, still doable in mssql but not as straight forward or efficient as mysql
select top 50 * from mytable where id not in (select top #pagesize# * #pagenumber# id from mytable) -----Original Message----- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: 28 September 2005 13:54 To: CF-Talk Subject: SQL row select? 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219408 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
