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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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?
ASKER
Nevermind - figured it out. Thank you for the example you've given me. I've awarded you the 500pts.
- Yvan
- Yvan
ASKER
What's up folks? Any thoughts?
- yg