Your problem is your query. Every time this page is called it is calling the query every time. So you need to either push the query into session var, and pull the records out 25 at a time or re write the query to pull 25 records out at a time.
Both have their pitfalls, session if any new records are added to the database then you have a problem of not showing these until the session times out. With the other method if a record is added, it will either the records down looking like its duplicating data. Anyway hope this helps. -----Original Message----- From: WebStop Internet Services [mailto:[EMAIL PROTECTED] Sent: Friday, 20 May 2005 5:47 PM To: CF-Talk Subject: next and previous records Help! This keeps failing after the first 25 records are displayed and it shows all records in the database 25 at a time not just the ones queried originally by say company_name. Anyone know why? <cfset todayDate = Now()> <!--- query the EmployeeDirectory table. Cache the result set for 15 minutes. ---> <CFPARAM NAME="StartRow" DEFAULT="1"> <CFPARAM NAME="DisplayRows" DEFAULT="25"> <cfquery name="getCompanyData" datasource="LOADDATA"> SELECT company_name, container_no, billdate,LOADDATA.ID, SUM(("IN" - out) * rate) AS total_rate, SUM("IN" - out) AS OnHand FROM rate_calc <cfif IsDefined("DUE")>WHERE BILLDATE > '#DateFormat(todayDate, "mm/dd/yy")#' <cfelseif isdefined("PASTDUE")>WHERE BILLDATE < '#DateFormat(todayDate, "mm/dd/yy")#' <cfelseif isdefined("TODAY")>WHERE BILLDATE = '#DateFormat(todayDate, "mm/dd/yy")#' <cfelseif isdefined("FORM.COMPANY_NAME")>WHERE COMPANY_NAME = '#company_name#' <cfelseif isdefined("FORM.CONTAINER_NO")>WHERE CONTAINER_NO = '#container_no#' </cfif> GROUP BY company_name, container_no, billdate, LOADDATA.ID ORDER BY company_name, CONTAINER_NO, BILLDATE </cfquery> <cfinclude template="header.cfm"> <!--- Set a variable to hold the record number of the last record to output on the current page. ---> <CFSET ToRow = StartRow + (DisplayRows - 1)> <CFIF ToRow GT getCompanyData.RecordCount> <CFSET ToRow = getCompanyData.RecordCount> </CFIF> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>Untitled Document</title> <style type="text/css"> <!-- INPUT, TEXTAREA, SELECT {font-family: Tahoma; font-size: x-small;} .cfmmaker {font-family: Tahoma; font-size: x-small;} .ewTableOrderIndicator {font-family: Webdings;} --> </style> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <CFOUTPUT> <H4>Displaying records #StartRow# - #ToRow# from the #getCompanyData.RecordCount# total records in your query.</H4> </CFOUTPUT> <table width="500" border="0" class="cfmmaker"> <tr bgcolor="##CCCCCC"> <td>Company Name</td> <td>Container Number</td> <td>Total Billable</td> <td>Bill Date</td> <td>On Hand</td> </tr> <CFOUTPUT query="GETCOMPANYDATA" STARTROW="#url.StartRow#" MAXROWS="#DisplayRows#"> <tr BGCOLOR="###IIF(GETCOMPANYDATA.currentrow MOD 2, DE('E6E6E6'), DE('C0C0C0'))#"> <td>#COMPANY_NAME#</td> <td><a href="loaddataContainerView.cfm?ID=#ID#">#CONTAINER_NO#</td> <td>#DollarFormat(total_rate)#</td> <td>#Billdate#</td> <td>#OnHand#</td> </tr> </CFOUTPUT> </table> <!--- update the values for the next and previous rows to be returned ---> <CFSET Next = StartRow + DisplayRows> <CFSET Previous = StartRow - DisplayRows> <!--- Create a previous records link if the records being displayed aren't the first set ---> <CFOUTPUT> <CFIF Previous GTE 1> <A HREF="loaddataSummaryResults.cfm?StartRow=#Previous#"><B>Previous #DisplayRows# Records</B></A> <CFELSE> Previous Records </CFIF> <B>|</B> <!--- Create a next records link if there are more records in the record set that haven't yet been displayed. ---> <CFIF Next LTE GETCOMPANYDATA.RecordCount> <A HREF="loaddataSummaryResults.cfm?StartRow=#Next#"><B>Next <CFIF (GETCOMPANYDATA.RecordCount - Next) LT DisplayRows> #Evaluate((GETCOMPANYDATA.RecordCount - Next)+1)# <CFELSE> #DisplayRows# </CFIF> Records</B></A> <CFELSE> Next Records </CFIF> </CFOUTPUT> <a href="javascript: history.go(-1)">Back</a> </body> </html> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:207264 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
