ORDER BY a column?

[kinsley]

Hello all,

If I have several fields:
a | b | c | d | e

and the original SQL = SQL & " ORDER BY a ASC ".

I want to place links to b, c, d, e to make the table of results to show by ascending order of b (or , c, d, e).

do I need to place an "if/ end if" in the sql or do I put some statement in the paging?

example
a (ORDER BY a ASC)| b | c | d | e
1 | 3 | z
2 | 2 | y
3 | 1 | x
4 | 5 | w
5 | 4 | v

to

a | b (ORDER BY b ASC)| c | d | e
3 | 1 | x
2 | 2 | y
1 | 3 | z
5 | 4 | v
4 | 5 | w

Thanks in advance -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[invincible]

Use a querystring

dim vOrderBy, strSQL

vOrderBy = ""
vOrderBy = request.querystring("ob")

strSQL = ""
strSQL = "SELECT * from tab_Whatever ORDER BY "&vOrderBy&" "

Your links would be <a href="link.asp?ob=a">Link</a>

Or you could even put little Up/Down arrows at the top of each column and then pass an ASC or DESC

Dim vOrderBy, vOrder, strSQL

vOrderBy = ""
vOrder = ""
strSQL = ""

vOrderBy = ""
vOrderBy = request.querystring("ob")

vOrder = ""
vOrder = request.querystring("o")

Select case vOrder
Case "a"
vOrder="ASC"
Case "d"
vOrder="DESC"
End Select

strSQL = " -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --