This content has been marked as final. Show 4 replies
In article <email@example.com> "whereskris"
> I have tried everything but can't get it working, I read a few
> forums and they said it couldn't be done so here's a challenge if
> anyone would like to accept it.
Don't know which forums you were reading but this is trivial in CF.
You can put the start record number & records per page in the URL and
use those to drive the query on each page. For extra performance, you
can cache the query in session scope so you don't have to hit the
database on each page.
Sean A Corfield -- (904) 302-SEAN
An Architect's View -- http://corfield.org/
Early May, near Minneapolis, MN
The world's ONLY enterprise engineering conference for ColdFusion
Thanks for letting me know it can be done
but any example code would be greatly appreciated.
Make your original recordset a session variable and then use query of queries to get what you need for each page.