Start your loop at the desired index. <cfloop from="21" to="40" index="i">
</cfloop> Adrian -----Original Message----- From: Joy Holman [mailto:[EMAIL PROTECTED] Sent: 05 May 2006 20:45 To: CF-Talk Subject: Displaying array items with Next-n Records functionality I want to show results from an array that's created from query results: <cfif (WebEx is 0 or WebEx is "") OR (RPMSClassesUp.WebEx is 1 and Compare("#dani#","#daniNow#") gt 0 and Compare("#DateFormat(RPMSClassesUp.StartDate)#","#nowDate#") is 0) OR (RPMSClassesUp.WebEx is 1 and Compare("#DateFormat(RPMSClassesUp.StartDate)#","#nowDate#") gt 0)> <cfset session.a_up[i][1]="RPMSClassesUp.UniqueClassID" /> <cfset session.a_up[i][2]="RPMSClassesUp.Title" /> <cfset session.a_up[i][3]="RPMSClassesUp.ClassDescription" /> </cfif> I could loop through the results, but I'd like to only display 20 records per page like you can do with cfoutput query: <CFOUTPUT query="RPMSClasses" STARTROW="#url.RowStart#" MAXROWS="#RecordDisplay#"> content </CFOUTPUT> <CFIF (#session.RowStart# GT 1) AND (#session.RowStart# LTE #RecordDisplay#)> <CFSET ROWBACK = 1> <CFELSE> <CFSET ROWBACK = #Evaluate(session.RowStart - RecordDisplay)#> </CFIF> <CFOUTPUT><tr><CFIF #ROWBACK# GTE 0><td colspan="2" align="left"><a href="#self#?module=#module#&option=#option#&sortChoice=#session.sortChoice# &rowStart=#ROWBACK#" class="ClassListTitleText"><<< Back</a></td><CFELSE><td colspan="2" align="left"></td></CFIF><CFIF #Evaluate(session.RowStart + RecordDisplay)# LTE #RPMSClasses.Recordcount#><td colspan="2" align="right"><a href="#self#?module=#module#&option=#option#&sortChoice=#session.sortChoice# &rowStart=#Evaluate(session.RowStart + RecordDisplay)#" class="ClassListTitleText">More Classes>>></a></td><CFELSE><td colspan="2" align="right"></CFIF></tr></CFOUTPUT> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239743 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
