Well, If the queries not too big, you could set it up as a session variable and navigate through it using the startrow/maxrow attributes of <cfoutput> or <cfloop>. Then you only have to track the row you are currently on. Next is easy - but previous is trickier if you are subtracking from a stored value to get the previous start row. In any case, this is only a viable option if session variables and query size are not standing in your way.
Mark Mark A. Kruger, MCSE, CFG www.cfwebtools.com <http://www.cfwebtools.com> ..no more brochures! 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. ______________________________________________________________________ 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
