If a user is requesting to view all entries in my business directory that begin with the letter 'A', I execute a query to pull all of these records from the database. Of course I don't want to display all 6000 records on one screen, that would take minutes to load and be hard to use. So I display 20 at a time, using the STARTROW and MAXROWS attributes of CFOUTPUT, and show next and previous buttons. I believe this is a common scenario.
Is there any way to get around the fact that we are pulling all 6000 records across the pipe for each request to display 20 more records? I am using MS SQL Server. I know there is a TOP keyword that I might be able to use to only grab the first 20, then the first 40, 60, etc records. That will help a lot, but its not perfect (it still can grab a lot more than the needed 20 records). So does anyone else have any other solutions they use? Thanks, -Ryan ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
