急,分页出错,帮我查一下,错在哪里!!!
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!--#include file="conn.asp"-->
<%
exec="select * from job"
set rs=server.CreateObject("adodb.recordset")
rs.open exec,conn,1,1
%>
<%
rs.Pagesize=2
page=clng(request("page"))
if page<1 or page=empty then page=1
if page>rs.pagecount then page=rs.pagecount
rs1.Absolutepage=page
%>
<HTML><HEAD>
<TITLE>厦门新世通科技有限公司</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<LINK
href="styleCn.css" type=text/css rel=stylesheet>
<LINK href="main.css"
type=text/css rel=stylesheet>
<LINK href="images/styleCn.css"
type=text/css rel=stylesheet>
<TABLE cellSpacing=0 cellPadding=0 width=778 align=center border=0>
<TBODY>
<TR>
<TD class=twoside>
<TABLE width="779" height="56" border=0 cellPadding=0 cellSpacing=0>
<TBODY>
<TR>
<TD vAlign=top width="344" rowSpan=2> <img src="newimages/logo.gif" width="88" height="63" align="left">
<img src="newimages/name.gif" width="250" height="55"></TD> <TD vAlign=top width="435"><IMG height=20
src="images/logoright.gif" width=435></TD>
</TR>
<TR>
<TD vAlign=top>
<DIV align=center></DIV>
<TABLE cellSpacing=0 cellPadding=0 width="94%" border=0>
<TBODY>
<TR>
<TD height=24>
<DIV align=right><A
href="index01.htm">中文</A> | <A
href="english/gsjj.htm">ENGLISH</A></DIV>
</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width=778 align=center border=0>
<TBODY>
<TR>
<TD class=twoside bgColor=#999999><IMG height=1
src="images/spacer.gif" width=1></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width=778 align=center border=0>
<TBODY>
<TR>
<TD class=twoside vAlign=top><div align="center"><img src="newimages/gsjj.jpg" width="770" height="88">
</div></TD>
</TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width=778 align=center border=0>
<TBODY>
<TR>
<TD class=twoside>
<TABLE cellSpacing=1 cellPadding=0 width=776 align=right border=0>
<TBODY>
<TR>
<TD width="12%" height=22 vAlign=center background="newimages/bg.gif">
<DIV class=head align=center><a href="index.htm">首页</a></DIV></TD>
<TD width="12%" vAlign=center background="newimages/bg.gif" class=line-left>
<DIV align=center><a href="gsjj.htm">公司简介</a></DIV></TD>
<TD width="12%" vAlign=center background="newimages/bg.gif" class=line-left>
问题点数:50、回复次数:6Top
1 楼linpast(网巧)回复于 2003-09-03 21:35:28 得分 0
*****************接上页的***************************
<DIV align=center><a href="asp/index03.asp">产品展示</a></DIV></TD>
<TD width="12%" vAlign=center background="newimages/bg.gif">
<DIV align=center><a href="news.htm">公司新闻</a></DIV>
</TD>
<TD width="12%" vAlign=center background="newimages/bg.gif" class=line-left>
<DIV align=center><a href="jywh.htm">企业文化</a></DIV></TD>
<TD width="12%" vAlign=center background="newimages/bg.gif" class=line-left>
<DIV align=center><a href="it.htm">销售网络</a></DIV></TD>
<TD width="14%" vAlign=center background="newimages/bg.gif" class=line-left>
<div align="center" class="font"><font size="2">人才招聘</font></div></TD>
<TD width="14%" vAlign=center background="newimages/bg.gif" class=esstage> <a href="guest/index.asp">留言板</a></TD>
</TR>
</TBODY>
</TABLE></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width=778 align=center border=0>
<TBODY>
<TR>
<TD class=twoside background=images/bodyDotBg.gif><IMG
height=1 src="images/spacer.gif" width=1></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width=797 align=center border=0>
<TBODY>
<TR>
<TD width="797" height=522 vAlign=top class=twoside> <table width="98%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="17%" height="30"><img src="newimages/small.gif" width="146" height="20"></td>
<td width="83%" rowspan="2" valign="top"> <% do while not rs.eof%>
<br>
<table width="98%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td width="26%"> </td>
<td width="28%">招聘职位:</td>
<td width="46%"> <% =rs("job") %> </td>
</tr>
<tr>
<td width="26%"> </td>
<td width="28%">数量:</td>
<td width="46%"> <% =rs("howmuch") %> </td>
</tr>
<tr>
<td width="26%"> </td>
<td width="28%">联系人:</td>
<td width="46%"> <% =rs("contractname") %> </td>
</tr>
<tr>
<td width="26%"> </td>
<td width="28%">联系方式:</td>
<td width="46%"> <% =rs("contract") %> </td>
</tr>
<tr>
<td width="26%"> </td>
<td width="28%">要求:</td>
<td width="46%"> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> <% =rs("content") %> </td>
</tr>
<tr>
<td colspan="3"><hr width="570"> </td>
</tr>
</table>
<%
i=i+1
if i>2 then exit do
rs1.movenext
loop
end if
%>
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><table width="100%" border="0" align="center" cellpadding="5" cellspacing="0">
<tr>
<form action=<%=myself%> method=get>
<td align="center">
<%
if page<>1 then %>
<a href=<%=myself%>?page=1><font color="#000000">第一页</font></a><font color="#000000">
</font> <a href=<%=myself%>?page=<%=(page-1)%>> <font color="#000000">上一页</font></a><font color="#000000">
<%
end if
if page<>rs.pagecount then
%>
</font> <a href=<%=myself%>?page=<%=(page+1)%>> <font color="#000000">下一页</font></a><font color="#000000">
</font> <a href=<%=myself%>?page=<%=rs.pagecount%>>
<font color="#000000">最后一页</font></a><font color="#000000">
<% end if %>
</font> <font style="font-size:9pt"> 输入页次:</font>
<input type=text name=page22 size=3 class="border">
<font style="font-size:9pt">页次:</font><font color=red style="font-size:9pt"><%=page%>/<%=rs.pagecount%></font>
共有记录<font color=red style="font-size:9pt"><%=rs.recordcount %></font>条
</td>
</form>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td valign="top"><img src="newimages/person.jpg" width="150" height="250"></td>
</tr>
</table></TD>
</TR></TBODY></TABLE>Top
2 楼aloxy(爱上牛肉面)回复于 2003-09-03 22:12:25 得分 0
错误信息?Top
3 楼tvhero(改学VB中...)回复于 2003-09-04 06:09:35 得分 0
这分我不要了,这么长,头晕!Top
4 楼511214(小少)回复于 2003-09-04 07:33:49 得分 20
rs.open exec,conn,3,1
试试Top
5 楼no820824()回复于 2003-09-04 08:05:30 得分 30
<!--#include file="conn.asp"-->
<%
i=0
sql="select * from user"
rs.open sql,conn,1,2
page=trim(request("page"))
if page="" then
page=1
end if
rs.pagesize=2
page=cint(page)
if page<1 then page=1
if page>rs.pagecount then page=rs.pagecount
rs.absolutepage=page
%>
<head></head>
<html>
<body>
<table width="566" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="199">Id</td>
<td width="211">User</td>
<td width="156">Pass</td>
</tr>
<% while not rs.eof and i<rs.pagecount %>
<% i=i+1 %>
<tr>
<td width="199"><%=rs("id")%></td>
<td width="211"><%=rs("user")%></td>
<td width="156"><%=rs("password")%></td>
</tr>
<%
rs.movenext
wend
%>
</table>
<%
if page<>1 then %>
<a href=admins.asp?page=1>第一页</a>
<a href=admins.asp?page=<%=page-1%>><<</a>
<% end if %>
<% if page<> rs.pagecount then %>
<a href=admins.asp?page=<%=page+1%>>>></a>
<a href=admins.asp?page=<%=rs.pagecount%>>最后一页</a>
<% end if %>
<p></p>
<% for o=1 to rs.pagecount %>
<a href=admins.asp?page=<%=o%>><%=o%></a>
<%
next
%>
</body>
</html>Top
6 楼liuhualiang(eppen)回复于 2003-09-04 09:11:28 得分 0
应该在if not rs1.eof then
rs1.Absolutepage=pageTop




