you could always use an additional query to get the next/prev docs. question -- how would the next/prev buttons work if you didn't have an ID or ordinal attached to them anyways?
-----Original Message----- From: Tony Gruen [mailto:[EMAIL PROTECTED]] Sent: Monday, January 14, 2002 20:02 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 ______________________________________________________________________ Get Your Own Dedicated Windows 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=coldfusionb 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
