Experts Exchange connects you with the people and services you need so you can get back to work.
Open in new window
The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!
iSortCol = Request("iSortCol_0")
sSortDir = Request("sSortDir_0")
'-- sanitize fields to make sure they are valid values
if iSortCol = "" or not isNumeric( iSortCol ) then iSortCol = -1
if LCase( sSortDir ) <> "asc" and LCase( sSortDir ) <> "desc" then sSortDir = "asc"
sortBy = "name" '-- default sort by column
select case iSortCol
case 0: sortBy = "place"
case 1: sortBy = "name"
case 2: sortBy = "school"
case 3: sortBy = "points"
sql = "select data from table where conditions = met order by " & sortBy & " " & sSortDir
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.