Sorting by asc or desc

[kastellu]

Hello, Could someone help me with this one. I would like to change the order by when clicking on link.My code:

<a herf = "index.asp?sort=asc">Products<%sort = request.querystring ("sort")If sort = asc then SORTBY = ascElseSORTBY = descsql ="SELECT * FROM tblExample ORDER BY '& SORTBY &';"%>

Am i on a right way or did i lose it fully.Thank you

[justsomeguy]

Close.

If sort = "asc" then SORTBY = "asc"ElseSORTBY = "desc"End If

[jesh]

You'll also need to specify which column you'll be sorting off of in the SQL query:

SELECT * FROM tblExample ORDER BY columnName DESC

[kastellu]

O.K. thanks !But here is another problem, how to put value , back to first one, when you click on it again!thanks