UC知道ASP中SQL语句降序为什么会无效??求救!!急!
来源：百度知道 编辑：UC知道 时间：2024/05/21 14:53:14
<%
strpage=request.querystring("page")
set conn = server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("db1.mdb")
set rs=server.createobject("adodb.recordset")
strsql="select id,title,detail from board order by idnum desc"
conn.execute(strsql)
rs.open "board",conn,3,3,adcmdtable
if rs.recordcount>0 then
sumcount = rs.recordcount
rs.movefirst
end if
rs.pagesize=12
intpagecount=rs.pagecount
%>
strpage=request.querystring("page")
set conn = server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("db1.mdb")
set rs=server.createobject("adodb.recordset")
strsql="select id,title,detail from board order by idnum desc"
conn.execute(strsql)
rs.open "board",conn,3,3,adcmdtable
if rs.recordcount>0 then
sumcount = rs.recordcount
rs.movefirst
end if
rs.pagesize=12
intpagecount=rs.pagecount
%>
rs.open "board",conn,3,3
改成
rs.open strsql,conn,3,3
strsql="select id,title,detail from board order by idnum desc"
如果你想实现id由大到小排序语句应该这样写：strsql="select id,title,detail from board order by id desc"
先看看你的idnum字段是不是为数值型?如果是的话.那么试试把你的SQL语句改为
strsql="select * from board order by idnum desc"
这句就已经行了.