Question

我用asp从数据库读出了一个表,请问如何实现点击一下表头的一个字段升序,再点击一下降序?

rt.
不是分页,例如我单击网页上表头的一个字段'成绩',那么'成绩'下面的数字升序排列,再点击一下'成绩',下面的数字降序排列,就是升降序交替.

我想要的是asp代码,不是asp.net.

Answer 1

<%
rOlderType = trim(request("orderType"))
if rOlderType="" or isNull(rOlderType) then
olderType = "asc"
else
olderType = rOlderType
end if
if olderType="asc" then
olderTypeStr = "desc"
else
olderTypeStr = "asc"
end if
rOlderField = trim(request("olderField"))
if rOlderField="" or isNull(rOlderField) then
olderField = "id"
else
olderField = rOlderField
end if
sql = "select * from [tableName] where 条件 order by " & orderField & " " & olderType
%>
<a href="?olderField=成绩&olderType=<%=olderTypeStr%>">成绩</a>

Answer 2

AJAX实现，其实你点表头有个javasrcipt脚本，传递一个值过去，然后通过数据库重新查询

Answer 3

点击降序链接到一个和升序一摸一样的网页，只不过把语句换为降序既可