主题:急!!急阿
<table border="0" width="100%" cellspacing="0" cellpadding="0" height="568" align="left" valign="top">
<tr valign="top">
<td width="100%" height="25" align="center" valign="top" background="images/topbg.gif"><font color="#FFFFFF">大类管理</font></td>
</tr>
<tr width="100%" valign="top">
<td width="100%" valign="top">
<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" class="t-1" valign="top">
<tr bgcolor="#CEDBEF">
<td align="center">大类ID</td>
<td align="center">大类名</td>
<td colspan="2" align="center">操 作</td>
</tr>
<%
page=request.querystring("pageNO")
set Rs = conn.execute("select * from sort order by id desc")
Rs.pagesize=10
if page="" then page=1
if not(isnumeric(page)) then page=1
if page<1 then page=1
page=int(page)
totalpage1=Rs.recordcount
totalpage=Rs.pagecount
if page>totalpage then page=totalpage
Rs.absolutepage=page //。。。。。错误行
i=0
do while not Rs.eof and i<Rs.pagesize
i=i+1
if i>10 then exit do %>
<tr valign="top" bgcolor="#CEDBEF" width="100%">
<td align=center valign="top"><%=rs("id")%></td>
<td valign="top"><%=rs("sort_title")%></td>
<td valign="top"><a href="sort.asp?act=modify&id=<%=rs("id")%>">修改</a></td>
<td valign="top"><a href="sort.asp?act=del&id=<%=rs("id")%>" onclick='return confirmdel();'>删除</a></td>
</tr>
<%Rs.movenext
loop%>
<%Rs.close
set Rs=nothing%>
<tr bgcolor="#CEDBEF">
<td colspan="2" align="left">页次 <font color=red><%=page%></font>/<font color=red><%=totalpage%></font> 页</td>
<td colspan="7" align="right">
大类总数<%=totalpage1%>个
分页>>
<%if PageNO-1>0 then %>
<A href="sort.asp?act=<%=act%>&pageNO=1">[首页]</a>
<A href="sort.asp?act=<%=act%>&pageNO=<%=pageNO-1%>">[前页]</a>
<%else%>
[首页] [前页]
<%end if%>
<%if PageNo+1<=MaxPage then%>
<A href="sort.asp?act=<%=act%>&pageNO=<%=pageNO+1%>">[后页]</a>
<A href="sort.asp?act=<%=act%>&pageNO=<%=Rs.pagecount%>">[末页]</a>
<%else%>
[后页] [末页]
<%end if%>
</td>
</tr>
</table>
</td>
</tR>
</table>
ADODB.Recordset 错误 '800a0bb9'
参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突。
/guoyan/cgi-bin/LUIYAN/sort.asp,行 83
<tr valign="top">
<td width="100%" height="25" align="center" valign="top" background="images/topbg.gif"><font color="#FFFFFF">大类管理</font></td>
</tr>
<tr width="100%" valign="top">
<td width="100%" valign="top">
<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" class="t-1" valign="top">
<tr bgcolor="#CEDBEF">
<td align="center">大类ID</td>
<td align="center">大类名</td>
<td colspan="2" align="center">操 作</td>
</tr>
<%
page=request.querystring("pageNO")
set Rs = conn.execute("select * from sort order by id desc")
Rs.pagesize=10
if page="" then page=1
if not(isnumeric(page)) then page=1
if page<1 then page=1
page=int(page)
totalpage1=Rs.recordcount
totalpage=Rs.pagecount
if page>totalpage then page=totalpage
Rs.absolutepage=page //。。。。。错误行
i=0
do while not Rs.eof and i<Rs.pagesize
i=i+1
if i>10 then exit do %>
<tr valign="top" bgcolor="#CEDBEF" width="100%">
<td align=center valign="top"><%=rs("id")%></td>
<td valign="top"><%=rs("sort_title")%></td>
<td valign="top"><a href="sort.asp?act=modify&id=<%=rs("id")%>">修改</a></td>
<td valign="top"><a href="sort.asp?act=del&id=<%=rs("id")%>" onclick='return confirmdel();'>删除</a></td>
</tr>
<%Rs.movenext
loop%>
<%Rs.close
set Rs=nothing%>
<tr bgcolor="#CEDBEF">
<td colspan="2" align="left">页次 <font color=red><%=page%></font>/<font color=red><%=totalpage%></font> 页</td>
<td colspan="7" align="right">
大类总数<%=totalpage1%>个
分页>>
<%if PageNO-1>0 then %>
<A href="sort.asp?act=<%=act%>&pageNO=1">[首页]</a>
<A href="sort.asp?act=<%=act%>&pageNO=<%=pageNO-1%>">[前页]</a>
<%else%>
[首页] [前页]
<%end if%>
<%if PageNo+1<=MaxPage then%>
<A href="sort.asp?act=<%=act%>&pageNO=<%=pageNO+1%>">[后页]</a>
<A href="sort.asp?act=<%=act%>&pageNO=<%=Rs.pagecount%>">[末页]</a>
<%else%>
[后页] [末页]
<%end if%>
</td>
</tr>
</table>
</td>
</tR>
</table>
ADODB.Recordset 错误 '800a0bb9'
参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突。
/guoyan/cgi-bin/LUIYAN/sort.asp,行 83