Knowledgebase

Home » Item #328

Listing versions alphabetically rather than by price

Item: #328
Date: 15 Nov 2002
Applies to
v4

Question

How do I list versions alphabetically rather than in order of price? Is it possible to make an order by button to select this?

Answer

The code that controls the ordering is in the prodtype.asp and products.asp pages. If you look at the end of the queries (there are several versions of some to deal with the different supported databases) they have an ORDER BY clause.

To change the ordering, look for "V_Price" after the ORDER BY part and change it to "V_Name".

There is no simple way to create an 'order' button that would retain any product selections already made to dropdowns or textboxes on the page.

Can't find the answer you need? Click here to open a support ticket.

« Back