<%
cc=request.form("kok")
if cc="ok" then
set conn=server.createobject("adodb.connection")
conn.open "driver={Microsoft Access driver (*.mdb)};dbq="&server.mappath("kk.mdb")
exec="select * from beok"
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,3
page=2
rs.pagesize=8
counts=5
allpages=rs.pagecount
rs.absolutepage=page
do while (not rs.eof) and counts>0 %>
<table width="536" height="235" border="1" cellpadding="1" cellspacing="0" bordercolor="#CCCCCC" bgcolor="#FFFFFF">
<tr bgcolor="#FFFFFF">
<td>ÐÕÃû</td>
<td>±¸×¢</td>
<td> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td><%=rs("min")%></td>
<td><%=rs("xin")%></td>
<td> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td></td>
<td> </td>
<td> </td>
</tr>
</table>
<%
counts=counts-1
rs.movenext
if rs.eof then exit do
loop
end if
end if
if page=2 then
response.write "前页 后页"
else
response.write "<a href=pageview.asp?page=1>首页</a>"
"<a href=pageview.asp?page="&page-1&">前页</a>"
end if
if page=allpages then
response.write "下页 末页"
else
response.write "<a href=pageview.asp?page="&page+1&">下页</a>
<a href=pageview.asp?page="&allpages&">末页</a>"%>
提示出错内容:
end if
if page=2 then
response.write "?? ??"
else
response.write "??"[0]Script error detected at line 40,col[0].
Source line: end if
Description: 缺少语句怎么会呢?请高手指导
cc=request.form("kok")
if cc="ok" then
set conn=server.createobject("adodb.connection")
conn.open "driver={Microsoft Access driver (*.mdb)};dbq="&server.mappath("kk.mdb")
exec="select * from beok"
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,3
page=2
rs.pagesize=8
counts=5
allpages=rs.pagecount
rs.absolutepage=page
do while (not rs.eof) and counts>0 %>
<table width="536" height="235" border="1" cellpadding="1" cellspacing="0" bordercolor="#CCCCCC" bgcolor="#FFFFFF">
<tr bgcolor="#FFFFFF">
<td>ÐÕÃû</td>
<td>±¸×¢</td>
<td> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td><%=rs("min")%></td>
<td><%=rs("xin")%></td>
<td> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td></td>
<td> </td>
<td> </td>
</tr>
</table>
<%
counts=counts-1
rs.movenext
if rs.eof then exit do
loop
end if
end if
if page=2 then
response.write "前页 后页"
else
response.write "<a href=pageview.asp?page=1>首页</a>"
"<a href=pageview.asp?page="&page-1&">前页</a>"
end if
if page=allpages then
response.write "下页 末页"
else
response.write "<a href=pageview.asp?page="&page+1&">下页</a>
<a href=pageview.asp?page="&allpages&">末页</a>"%>
提示出错内容:
end if
if page=2 then
response.write "?? ??"
else
response.write "??"[0]Script error detected at line 40,col[0].
Source line: end if
Description: 缺少语句怎么会呢?请高手指导
解决方案 »
- 哪种报表控件可以画出这样的报表
- Database类和Dbcommand
- 如何实现自动识别手机型号?
- .Net Datarow循环
- 客户端调用webservice出错:基础连接已经关闭:无法连接到远程服务器
- DataList、DataGrid等“删除”前提示框的两种实现方法!
- 100分,datagrid问题请教,在线等
- [TreeView]是不是webctrl_client目录一定要放于站点根目录下?
- 权威规范的网址中不能出现哪些字符?
- 水晶报表的问题,用过水晶报表帮忙我看看吧,急!
- datalist中绑定数据,数据过长,不能自动换行,把单元格撑的变形,球解决办法!!!
- MS Ajax.net.modalPopup组件的使用问题.
第一个
if rs.eof then exit do
loop
end if
end if
多了一个end if
第二个地方
最后
if page=allpages then
response.write "下页 末页"
else
response.write "<a href=pageview.asp?page="&page+1&">下页</a>
<a href=pageview.asp?page="&allpages&">末页</a>"少了一个end if
另外提一句,你把代码缩进下,注意下格式,以后调试也结构清晰。
cc=request.form("kok")
if cc="ok" then
set conn=server.createobject("adodb.connection")
conn.open "driver={Microsoft Access driver (*.mdb)};dbq="&server.mappath("kk.mdb")
exec="select * from beok"
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,3
page=2
rs.pagesize=8
counts=5
allpages=rs.pagecount
rs.absolutepage=page
do while (not rs.eof) and counts>0 %>
<table width="536" height="235" border="1" cellpadding="1" cellspacing="0" bordercolor="#CCCCCC" bgcolor="#FFFFFF">
<tr bgcolor="#FFFFFF">
<td>ÐÕÃû</td>
<td>±¸×¢</td>
<td> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td><%=rs("min")%></td>
<td><%=rs("xin")%></td>
<td> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td></td>
<td> </td>
<td> </td>
</tr>
</table>
<%
counts=counts-1
rs.movenext
if rs.eof then exit do
loop
end if
end if
if page=2 then
response.write "<font color=darkgray>前一页 末页</font>"
else
response.write "<a href=pageview.asp?page=1>首页</a>
<a href=pageview.asp?page="&page-1&">前页</a>"
end if
if page=allpages then
response.write "<font color=red>后一页 首页</font>"
else
response.write "<a href=pageview.asp?page="&page+1&">下页</a>
<a href=pageview.asp?page="&allpages&">末页</a>"
end if
%>
前一个end if删除了还是出错,所以没删.
增加了后一个end if后还是出错提示内容
end if
if page=2 then
response.write "??? ??"
else
response.write "??[0]Script error detected at line 40,col[0].
Source line: end if
Description: 缺少语句怎么还是这样呢?...