asp高手进来看一下,小弟谢谢您了

来源：百度知道 编辑：UC知道 时间：2024/06/27 13:11:04
<!-- #include file="conn.asp" -->
<style type="text/css">
<!--
#Layer2 {
position:absolute;
left:57px;
top:70px;
width:870px;
height:74px;
z-index:2;
}
-->
</style>
<table width="870" border="1" align="center" cellpadding="0" cellspacing="1" bordercolor="#000000">
<tr>
<td width="204" height="15" colspan="3" align="center" bgcolor="#FFFFFF">名称</td>
<td width="230" align="center">价格</td>
<td width="313" align="center">备注</td>
</tr>
<%
set rs=server.CreateObject("adodb.recordset")
sql="select ProductID,ProName,Price,Other from Product"
rs.open sql,conn,3,1
page=request.QueryString(

sql="select ProductID,ProName,Price,Other from Product"
rs.open sql,conn,1,3 '改这里
page=request.QueryString("page")
rs.pagesize=5

....
sql="select ProductID,ProName,Price,Other from Product"
rs.open sql,conn,1,1
if not rs.eof then
rs.pagesize=5
n=1
if cint(request("page"))="" then
page=1
else
page=cint(request("page"))
end if
If Page > rs.PageCount Then Page = rs.PageCount
rs.absolutepage=page
while not rs.eof and n<rs.pagesize
...
....
end if
.....

if cint(request("page"))="" then
page=1
else
page=cint(request("page"))
end if
这段,改成
if request("page")="" then
page=1
else
page=cint(request("page"))
end if

放在ASP的最上面

sql="select Prod