OK, I'm trying to do something funky and can't quite seem to make it click.
I run a big ass query, get some results, use CFOUTPUT to output those results. I use a variable that I reset with each new DB row output in order to find the last row ID of the query results.
Now, what I'd like to do find the next 5 most recent entries in the DB, starting from that last row ID.
So database has rows 1-20. My first query looks like:
1 2 3 4
I want the results of my second query to be:
5 6 7 8 9 10
Makes sense? How would I do such a thing?
Thanks! Jake
----------------------------------------------------------
To post, send email to [email protected]
To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
