On a clothing site for example.

Is it possible to create a recordset that will sort by "size" then "price".

To perform 1 sort is easy but does anyone know what code needs to be added to the sort to allow the secondary sort to work.

ASP/ACCESS/VBSCRIPT

Best Regards

Davrus

IN your recordset sql enter this

ORDER BY Size ASC, Price ASC

To reverse the order replace ASC with DESC

And be careful if you're using a SQL DB cause some datatypes CANNOT be used in an ORDER BY clause.

Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])