Hi Ron, Check out this tag from the dev exchange.
http://devex.macromedia.com/developer/gallery/info.cfm?ID=9447D363-8215- 11D5-83F800508B94F380&method=Full I use it for the same thing and have it sorting by dates, names and whatever else is needed to sort and display only a few records at a time. Works well and simple to implement. It is quite basic but you can just add to it. Blake ------------------------------------------------------------------------ ----------- Blake Foss Web Foot Forward p: 61 2 9340 4401 f: 61 2 8080 8190 m: 0410 747 620 e: [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ron Ziemiecki Sent: Saturday, 22 February 2003 11:08 AM To: CFAussie Mailing List Subject: [cfaussie] Logic help Hi again. I have a database with more than 20 results and am limiting the output to a page to 20. I can't get the logic right to make the second display page show the next 20 items because I can't use the _ID because the entries go into the database in a random number fashion. Here is the current code to display 20 items. <cfquery name="BODYBUILDING" datasource="#db_datasource#" username="#db_username#" maxrows="20"> select * FROM athlete WHERE athlete_sport = 'BODY BUILDING' order by athlete_surname ASC </cfquery> It seems to me that I might have to make another query that gathers all the _ID's from the database, and assigns them numbers and then get them to display in numerical order 20 per page. Trouble with that is, how do I get the numbers in the first place, bearing in mind entries in Body Building may have _ID's like: 23, 47, 125, 228, 229, 314 and so on. The _ID's are given as people register which is totally at random. There are other sports also which have _ID's given to them, so my initial query must contain the name of the sport, in this case Body Building. Any ideas how to get the next twenty ( a different 20) athletes, who are body builders to display? Thnx, send any suggestion, I have the whole weekend to try and figure this out. Ron... ____________________________________________________ IncrediMail - Email has finally evolved - Click Here --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
