You would use CURRENTROW to find out what position you are at in the queries recordset.
If the CURRENTROW is equal to the last record in the recordset, set the NEXT link to 1 (which will put you back at the beginning of the recordset) If you need a better explanation, let me know. HTH, Joseph DeVore VeloxWeb Technologies -----Original Message----- From: Tony Gruen [mailto:[EMAIL PROTECTED]] Sent: Monday, January 14, 2002 8:02 PM To: CF-Talk Subject: Mental Block Hello Awesome List-ers, I am suffering mental block. I cannot envision a creative solution to the following item. I am hopeful that someone here can offer an insightful thought trigger... I am building a system to view documents in a few categories. You will select a document and see that one entry. I want to have [next doc] [prev doc] buttons to move through the other documents in the chosen category. Trouble is that depending on the original document selected you could be in the middle, at the end or beginning of the subset and the unique id from the database is not sequential for the category subset. I know I will be embarrassed when someone points out the obvious to me but I am at an impasse. All thoughts are welcome. Tony Gruen ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
