View Full Version : Asp Sort=desc

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


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.