Let the user choose what column to sort on让用户选择让哪个栏目进行排序
时间:2009-03-04 16:41来源: 作者:admin 点击:
次
|
ID
|
Name
|
<%
if request.querystring("sort")<>"" then
sort=request.querystring("sort")
else
sort="webid"
end if
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/db/demo.mdb"))
set rs=Server.CreateObject("ADODB.recordset")
sql="SELECT WebID, WebName FROM Web ORDER BY " & sort
rs.Open sql,conn
do until rs.EOF
response.write("")
for each x in rs.Fields
response.write("| " & x.value & " | ")
next
rs.MoveNext
response.write(" ")
loop
rs.close
conn.close
%>
本文来源于：IT学习网 http://www.itxuexi.com/learn/7965.html
|
------分隔线----------------------------
我要投稿