inserting hyperlinks to sort data

bla4free · #1 (**permalink**) 03-09-05, 11:01

I have an asp page which displays the results of a query. is there a way to insert hyperlinks above the data so when clicked, it will sort the data ascending/descending...something like that. here's an example. i have my table. at the top of the table i have the column names. i want to hyperlink the column names so when clicked, it will sort the data based on that column. thanks for any help.

rokslide · #2 (**permalink**) 03-09-05, 17:12

If you want to sort you need to re-run the query that collected the data and add and orber by clause.... eg

Code:

select * from cases order by caseNumber

(of course don't use * specify your fields)

So you make the order by part of your sql statement dynamic and pass the field you want to order by in the querystring... something like...

Code:

<a href="caseResults.asp?orderby=caseNumber">Case Number</a>

and

Code:

strSql = "select * from cases"
orderBy = Request.QueryString("orderby")
if orderBy<>"" then strSql = strSql + "order by " orderBy

if you have a where clause included in the query you will need to make sure you have access to the data for this where clause as well.

Bullschmidt · #3 (**permalink**) 03-09-05, 21:59

And here's a related resource:

Database Sort
http://www.asp101.com/samples/db_sort.asp

Internet Services

Web Development

Digital Marketing

Consumer Tech