Link to home
Start Free TrialLog in
Avatar of egoselfaxis
egoselfaxis

asked on

Fancy pagination controls and sorting functions for query results using ColdFusion

http://www.thebookco.com/NEWSITE/COMPS/TBC_NewWebDesign_Results.jpg

The screenshot above depicts what it is I'm trying to accomplish with regards to pagination controls and sorting functions (I need to accomplish this using ColdFusion).

Here are the various different features that I need to replicate:

* The displaying of 3 records per row (and proper displaying of the last records returned from the query)
* The little "SORT BY" dropdown box that allows for the sorting based on 3 different criteria
* The "SHOW" dropdown box that allows for controlling how many items are displayed per page.
* The "<< PREV 1  2  3  4  5  6  7  8  9  NEXT >>" pagination controls.

Could someone please post an example that demonstrates how I might accomplish this using Coldfusion?

Ideally, I'd like to have something that's procedural rather than object oriented, as I am not using any kind of framework.  Also, it'd be great if the use of query string parameters could be avoided somehow --- though I'll gladly accept and use examples that require them if that makes things too complicated.

Thanks in advance,
- Yvan



Avatar of egoselfaxis
egoselfaxis

ASKER

chirp .. chirp .. [ sound of crickets ]

What's up folks?  Any thoughts?

- yg
ASKER CERTIFIED SOLUTION
Avatar of gdemaria
gdemaria
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Is there any way to adapt your example so that it displays the query results by displaying 3 items per row?  I can't seem to figure that part out.

Thanks,
- Yvan
what do you mean by 3 items per row?   Are you saying a  <table> with three columns <td>  for each record of the query?
Nevermind - figured it out.  Thank you for the example you've given me.  I've awarded you the 500pts.

- Yvan