How to order results page record set with a list menu

Question

OK - I'm stuck with something I would have thought to be pretty easy. I have a results page for an ecommerce site and I would like to have a list menu box that allows the user to select to sort the results by the standard stuff in the record set - price ASC / DSC - Brand ASC/DSC. Can I find a way to do it ? No and on hunting for the past few hours havent come accross a solution.

I'm using ASP with Access and DW 8.

Heelllllppppppppp

Cheers

DW

Lawrence_Cramer · Answer

I'm more a CF guy so I can't give you the exact code, but here's the principle involved...

In you SQL query for the record set populate your ORDER BY statement dynamically based on a session or URL variable. You would set a default vale of a field... say the date, but allow the user to select something else and if they do reset the variable based on their selection. A session variable would likly be the best way to do this so the setting would be "remembered" as long as the user is on the site.

Hope this helps point you in the right direction.

Lawrence *Adobe Community Expert*
www.Cartweaver.com
Complete Shopping Cart Application for
Dreamweaver, available in ASP, PHP and CF

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded