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