asp分页问题
小弟有一分页问题.代码如下
<%@ Language=VBScript %>
<!--#include file="conn_access.asp"-->
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<table width="100%" height="216" border="0" cellpadding="0" cellspacing="0">
<tr>
<form action=test.asp method="post" name="search" onsubmit="return FormSubmit()">
<td>
<table width="97%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="34%" height="20" align="right" valign="bottom"><IMG height=20 src="IMAGES/asd.gif" width=103></td>
<td width="31%"> 型号:
<input name="cpxh" size="14" maxlength="50" value=""></td>
<td width="14%"><INPUT type=submit value=查询 name=submit_afei>
</td>
<td width="15%">
</td>
<td width="6%"></td>
</tr>
</table></td>
</form>
</tr>
<tr>
<td height="287" align="center" valign="top">
<table width="100%" border="0" cellspacing="1" cellpadding="1">
<tr >
<td align="center" width="20%" height="20"><font color="#339933">型号:</font></td>
<td align="center" width="20%" height="20"><font color="#339933">厂牌:</font></td>
<td align="center" width="20%" height="20"><font color="#339933">数量:</font></td>
<td align="center" width="20%" height="20"><font color="#339933">批号:</font></td>
<td align="center" width="20%" height="20"><font color="#339933">价格:</font></td>
</tr>
<%
'xh = "AMP"
xh = Request.Form("cpxh")
'Response.Write(xh)
set rs=Server.CreateObject("ADODB.Recordset")
Set rs.ActiveConnection=conn
rs.CursorType=3
rs.Open "select * from cpxh where cpxh like '%" & xh & "%'"
rs.PageSize=20
page=Clng(Request.QueryString("page"))
if page<1 then
page=1
end if
if page>rs.PageCount then
page=rs.PageCount
end if
rs.AbsolutePage=page
for i=1 to rs.PageSize
varNo =(page-1)*rs.PageSize+i
%>
<tr bgcolor=#EAF4FE >
<td align="center" width="20%" height="20"><%=rs.Fields("cpxh").Value%></td>
<td align="center" width="20%" height="20"> </td>
<td align="center" width="20%" height="20"><%=rs.Fields("cpcount").Value%></td>
<td align="center" width="20%" height="20"> </td>
<td align="center" width="80%" height="20"> </td>
</tr>
<%
rs.MoveNext
if rs.EOF then exit for
next
%>
<tr>
<td colspan=5 align="center" height="20">
<%
Response.Write(rs.PageCount)
if page=1 then
Response.Write("第一页")
else
Response.Write("<a href=test.asp?page=1>[第一页]</a>")
end if
if page=1 then
Response.Write("上一页")
else
Response.Write("<a href=test.asp?page="&page-1& ">[上一页]</a>")
end if
if page=rs.PageCount then
Response.Write("下一页")
else
Response.Write("<a href=test.asp?page="&page+1&">[下一页]</a>")
end if
if page =rs.PageCount then
Response.Write("最后一页")
else
Response.Write("<a href=test.asp?page="&rs.PageCount&">[最后一页]</a>")
end if
conn.Close
if conn.State =0 then
end if
set conn=nothing
%>
</td></tr><table></BODY></HTML>
问题是,第一页能够按照查找的关键字显示的,但是第二页以后就不能 正常显示。他显示的是数据库里面全部的记录。
恳请解答一二!