I agree with Peter's comments. This problem doesn't make much sense. No one is
going to scroll through a recordset of 125,000 records one page at a time.
Let's see, at 25 records per page, the chances of finding what you might be
looking for is 1/5000! What kind of an application is that? I've seen similar
applications on some web sites. You're presented with a screen of maybe the
first 25 alphabetical records and some text like '1 to 25 of 637 items'. Then
there's no way to jump to page 10 and no way of having the system present, say,
200 records per page. I can't see many users putting up with that.
Nonetheless, I would think something like the following might work in this case:
<cfquery name="myquery" datasource="#mydsn#">
SELECT TOP 25 *
FROM mytable
WHERE somefield > #thelastone#
ORDER BY somefield
</cfquery>
<!--- Note the last item retrieved --->
<cfif myquery.recordcount>
<cfset thelastone = myquery[myquery.recordcount].somefield>
</cfif>
Pass that value along as a starting point for the next page.
Jim
-----Original Message-----
From: Paul Mone <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Date: Saturday, November 18, 2000 10:05 PM
Subject: RE: scaleability of <cfoutput maxrows=x>
>Maybe you could do this?
>
>SELECT TOP 25 *
>FROM TABLE
>WHERE IDField NOT IN (#List_Of_IDs_Viewed_Already#)
>ORDER BY SomeField
>
>You could keep track of all the ids you've viewed already and store them in
>a hidden form field?
>
>Hmmm. At the end you'd have a list with 124,975 IDs in it. I guess that
>sucks.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
