Asp Sort=desc

Hi, I am trying to sort a category o the fly. I have this string

Code:

---

xxxxxx.asp?CategoryID=<%=lngCategoryID%>&sort=desc

---

I dont know if its right, I am trying to combine a category with the sort=desc


I have added sort to my sql

Code:

---

Order By Rnd([PostCardID])" & sort & " "

---

Again I dont know if I have to make a new sql query or if I can just add it to the old one?

and query it with

Code:

---

<%
    sort = Request.Querystring("sort")   
%>

---

Trouble is it doesnt alter the display. They come out as they do normaly. Am I missing anything?

Thanks is advance for any help.
Richard