Here are a bunch of ways: http://www.google.co.uk/search?hl=en&q=coldfusion+next+n+results&meta=
Have a tinker, I'm sure you'll find a way you prefer. Adrian -----Original Message----- From: Riaan Venter [mailto:[EMAIL PROTECTED] Sent: 16 July 2007 09:18 To: CF-Talk Subject: Breaking up a DB query into pages Hi What would be the best way to only show 9 results from a DB query on a page and then have a next button and show the next 9 there after, and so on. Do I have to read the query into a structure or is there a way I can use the <cfloop> function. Thanks! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283742 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
