ASP分页不会做。。。
Vieky 2008-02-07 02:23:01 这是我的代码。
<!--#include file="conn.asp"-->
<!--#include file="chkadmin.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<link href="inc/style.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="680" border="0" align="center" cellpadding="2" cellspacing="0" bgcolor="#EEEEEE">
<tr bgcolor="#708090">
<td colspan="5" align="center" class="TdBorderB"><font color="#FFFFFF">按分类查看</font></td>
</tr>
<tr align="center">
<td class="TdBorderRB"><a href="article_list.asp?aclass=1">新闻焦点</a></td>
<td class="TdBorderRB"><a href="article_list.asp?aclass=2">媒体报道</a></td>
<td class="TdBorderRB"><a href="article_list.asp?aclass=3">家教公告</a></td>
<td class="TdBorderRB"><a href="article_list.asp?aclass=4">家政公告</a></td>
<td class="TdBorderRB"><a href="article_list.asp">查看所有</a></td>
</tr>
</table>
<br>
<form name="form1" method="post" action="article_list.asp?s=ok">
<table width="680" border="0" align="center" cellpadding="2" cellspacing="0" bgcolor="#EEEEEE">
<tr bgcolor="#708090">
<td colspan="5" align="center" class="TdBorderB"><font color="#FFFFFF">按关键词查看</font></td>
</tr>
<tr align="center">
<td class="TdBorderRB">请输入关键词</td>
<td class="TdBorderRB"><input name="keyword" type="text" class="input" id="keyword" size="30"></td>
<td class="TdBorderRB">请选择分类</a></td>
<td class="TdBorderRB"><select name="aclass">
<option value="1">新闻焦点</option>
<option value="2">媒体报道</option>
<option value="3">家教公告</option>
<option value="4">家政公告</option>
<option value="" selected>所有分类</option>
</select>
</td>
<td class="TdBorderRB"><input name='Submit' type='submit' class='button' value=' 给我搜 '></td>
</tr>
</table>
</form>
<br>
<table width="680" border="0" align="center" cellpadding="2" cellspacing="0" bgcolor="#EEEEEE">
<tr bgcolor="#708090">
<td width="85" align="center" class="TdBorderB"><font color="#FFFFFF">文章分类</font></td>
<td width="240" align="center" class="TdBorderB"><font color="#FFFFFF">文章标题</font></td>
<td width="70" align="center" class="TdBorderB"><font color="#FFFFFF">录入员</font></td>
<td width="136" align="center" class="TdBorderB"><font color="#FFFFFF">录入时间</font></td>
<td width="60" align="center" class="TdBorderB"><font color="#FFFFFF">点击数</font></td>
<td width="65" align="center" class="TdBorderB"><font color="#FFFFFF">操作</font></td>
</tr>
<%
dim rs,sql,ID,title,writer,writedate,aclass,hit
dim aclass2,s
aclass2=Request.QueryString("aclass")
s=Request.QueryString("s")
if aclass2="" then
sql="select * from article order by id desc"
else
sql="select * from article where aclass='"&aclass2&"' order by id desc"
end if
if s="ok" then
dim aclass3,keyword
aclass3=Request.Form("aclass")
keyword=Trim(Request.Form("keyword"))
if aclass3="" then
sql="select * from article where title like '%"&keyword&"%' order by id desc"
else
sql="select * from article where aclass='"&aclass3&"' and title like '%"&keyword&"%' order by id desc"
end if
end if
set rs=conn.execute(sql)
if rs.eof and rs.bof then
if s="ok" then%>
<tr><td colspan=6 class=TdBorderRB>☆你搜索的是“<font color="#FF0000"><B><%=keyword%></B></font>”,结果如下:</td></tr>
<%end if
response.write "<tr><td colspan=6 align=center class=TdBorderRB>没有内容...</td></tr>"
else
if s="ok" then%>
<tr><td colspan=6 class=TdBorderRB>☆你搜索的是“<font color="#FF0000"><B><%=keyword%></B></font>”,结果如下:</td></tr>
<%end if
do while not rs.eof
ID=rs(0)
title=rs(1)
writer=rs(3)
writedate=rs(4)
aclass=rs(5)
hit=rs(6)
if aclass="1" then
aclass="新闻焦点"
elseif aclass="2"then
aclass="媒体报道"
elseif aclass="3"then
aclass="家教公告"
elseif aclass="4"then
aclass="家政公告"
end if
%>
<tr>
<td align="center" class="TdBorderRB"><%=aclass%></td>
<td class="TdBorderRB"><%=title%></td>
<td align="center" class="TdBorderRB"><%=writer%></td>
<td align="center" class="TdBorderRB"><%=writedate%></td>
<td align="center" class="TdBorderRB"><%=hit%></td>
<td align="center" class="TdBorderRB"><a href="friend_edit.asp?id=<%=ID%>">修改</a> <a href="friend_del.asp?id=<%=ID%>">删除</a></td>
</tr>
<%
rs.movenext
loop
end if
set rs=nothing
%>
</table>
<!--#include file="footer.asp"-->
</body>
</html>
<%
conn.close
set conn=nothing%>
本人刚学ASP,我按网上一些实例做分页做不出。。出什么游标不可用的,有没有高手可以帮我将这个页面的代码改改,加个分页功能,或者教我怎么解决什么游标的问题。谢谢先了。。。