我把代码帖出来了给大家看看!
我把代码帖出来了给大家看看!
一个管理系统出错了
请你浏览这个文件中的manage.asp 然后点击工程部,当点击下一页时却错了
提示是56行错,也就是rs.absolutepage=pageno行错了,请帮我看一看!谢谢!
这是MANAGE.ASP
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<table width="701" height="369" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="112" align="left" valign="top"> <table width="100%" border="0" cellspacing="0" cellpadding="10">
<tr>
<td align="center"><a href="show.asp?bm=工程部">工程部</a></td>
</tr>
<tr>
<td align="center"><a href="show.asp?bm=研发部">研发部</a></td>
</tr>
<tr>
<td align="center"><a href="show.asp?bm=市场部">市场部</a></td>
</tr>
<tr>
<td align="center"><a href="show.asp?bm=销售部">销售部</a></td>
</tr>
<tr>
<td align="center"><a href="show.asp?bm=行政部">行政部</a></td>
</tr>
</table></td>
<td width="583"> </td>
</tr>
</table>
</body>
</html>
这是SHOW.ASP 提示是56行错,也就是rs.absolutepage=pageno行错了,请帮我看一看!谢谢!
<%
dim bm
bm=request("bm")
set db=server.createobject("adodb.connection")
db.open"dbq="&server.mappath("jhzj.mdb")&";driver={microsoft access driver (*.mdb)};"
set rs=server.createobject("adodb.recordset")
sql="select * from manage where bm='"&bm&"'"
rs.open sql,db,1,2
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<table width="700" border="1" align="center" cellpadding="2" cellspacing="0">
<tr align="center">
<td width="150">部门计划与总结</td>
<td width="99">行政管理</td>
<td width="93">交流中心</td>
<td width="178">公共信息</td>
<td width="148">上报文件</td>
</tr>
</table>
<table width="701" height="369" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="112" align="left" valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="10">
<tr>
<td align="center"><a href="show.asp?bm=工程部">工程部</a></td>
</tr>
<tr>
<td align="center"><a href="show.asp?bm=研发部">研发部</a></td>
</tr>
<tr>
<td align="center"><a href="show.asp?bm=市场部">市场部</a></td>
</tr>
<tr>
<td align="center"><a href="show.asp?bm=销售部">销售部</a></td>
</tr>
<tr>
<td align="center"><a href="show.asp?bm=行政部">行政部</a></td>
</tr>
</table></td>
<td width="583" align="center" valign="top">
<%
pageno=cint(request.querystring("pageno"))
i=3
rs.pagesize=i
mpage=rs.pagecount
if pageno<1 or pageno="" or pageno>mpage then
pageno=1
end if
rs.absolutepage=pageno
%>
<%
do while not rs.eof and i>0
i=i-1
%>
<table width="90%" height="72" border="1" align="center" cellpadding="0" cellspacing="0">
<tr align="center">
<td height="18" colspan="6"><%=rs("lx")%></td>
</tr>
<tr>
<td width="10%" height="34">部门:</td>
<td width="22%"><%=rs("bm")%></td>
<td width="9%">经理:</td>
<td width="23%"><%=rs("manage")%></td>
<td width="13%">日期:</td>
<td width="23%"><%=rs("hbdate")%></td>
</tr>
<tr>
<td height="18" colspan="6"><%=rs("lyhb")%></td>
</tr>
</table>
<%
rs.movenext
loop
%>
<table width="90%" border="1" cellpadding="0" cellspacing="0">
<tr>
<td>
<%
if pageno>1 then
response.write"<a href=show.asp?pageno="&(pageno-1)&">上一页</a> "
end if
if pageno<mpage then
response.write"<a href=show.asp?pageno="&(pageno+1)&">下一页</a>"
end if
%>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>