I am trying to get the SQL statement to order by a URL Query String that is called category.
I can't seem to get this work.
I have tried:
"SELECT * FROM dbo.rockers ORDER BY [(Request.QueryString("category"))]"
"SELECT * FROM dbo.rockersORDER BY" &<% = Request.QueryString("category") %>
Thank you in advance.