I would say sqlserver if you can... Altho I cant remember where I saw how to do this...
It will definitely save getting all 7 odd thousands requests on each page... Unless you cache the resultset on the first call... HTH -----Original Message----- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 4, 2003 10:06 To: CF-Talk Subject: Previous and Next in Page Hi, All I want is to have total results obtained from query at end of my page and show 20 on each page with an option to go to PREVIOUS or NEXT 20. So it should be something like Showing results 1 - 20 of 500 <PREVIOUS> <NEXT> Whats best approach to do it in Coldfusion/SQLServer???? Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY !"[EMAIL PROTECTED]@APOLLO"! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
