In my continued fascination with Pagination i am detailing how to achieve it with AJAX (Jquery/JSON really) and Coldfusion. You can see a running example of the code here, and download all the code here. If you are interested in learning Jquery i recommend reading the book Learning Jquery.
I am describing here how i achieve pagination in my Model Glue apps. I hope the code is modular enough to be reused in other people's apps. You can see a running example here. The code mainly consists of a custom tag (cf_paginationMG) located in the view, and a coldfusion component (Pagination cfc) placed in the model. These both have straightforward APIs that can be easily wired via your controller. In your view, the event that generates the pagination can be labelled anything you like. As long as it calls a function you have defined in your controller that in turn invokes the pagination component. A seperate component is needed in the model that returns to the controller the actual record set that needs to be paged. You can see how i have done this in source code of my example.
When ever i have added a new site via IIS none of the ajax features in Coldfusion 8 functioned - no response whatsoever. It seems that when i ran the web server connector tool it was not adding a virtual CFIDE directory to my new site in IIS, just a JRUN scripts directory. To get around this you need to manually add a virtual CFIDE directory with the local path pointing to location of the CFIDE in inetpub (on my server this is C:\inetpub\wwwroot\CFIDE and set the directory execute permissions to Scripts and Executables.