How to order results page record set with a list menu

Report · May 20, 2009

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

Report · May 20, 2009

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