PDA

View Full Version : Asp Sort=desc



rich1234
10-05-2007, 08:36 AM
Hi, I am trying to sort a category o the fly. I have this string




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



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


<%
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