急!报表显示问题?数据库跟踪有数 asp界面调试没有数据呢
时间:2011-06-24
来源:互联网
set rs = server.CreateObject("adodb.recordset")
sql="select a.rukushijian ,sum(cast(b.rkjiagehe as float)) as sumRkjagehe"
sql= sql& " from pro_rukujiben a, pro_rukudan b where a.rukubianhao=b.rukubianhao and a.rukushijian between '"&date1&"' and '"&date2&"' group by a.rukushijian"
rs.PageSize = 25
rs.CursorLocation = 3
rs.Open sql,conn,0,2,1
pre = true
last = true
page = trim(Request.QueryString("page"))
if len(page) = 0 then
intpage = 1
pre = false
else
if cint(page) =< 1 then
intpage = 1
pre = false
else
if cint(page) >= rs.PageCount then
intpage = rs.PageCount
last = false
else
intpage = cint(page)
end if
end if
end if
if not rs.eof then
rs.AbsolutePage = intpage
end if
%>
<div align="center">
<table width="766" height="34" border="0" cellpadding="1" cellspacing="0">
<tr class="tr_southidc">
<td><table width="766" height="34" border="0" cellpadding="1" cellspacing="0">
<tr class="back_southidc">
<td width="113"><div align="center">日期</div></td>
<td width="113"><div align="center">合计金额</div></td>
</tr>
<%
for i=1 to rs.PageSize
if not rs.EOF or not rs.BOF then exit for
%>
<tr class="tr_southidc">
<td><div align="center"><%=rs("rukushijian")%></div></td>
<td><div align="center"><%=rs("sumRkjagehe")%></div></td>
sql="select a.rukushijian ,sum(cast(b.rkjiagehe as float)) as sumRkjagehe"
sql= sql& " from pro_rukujiben a, pro_rukudan b where a.rukubianhao=b.rukubianhao and a.rukushijian between '"&date1&"' and '"&date2&"' group by a.rukushijian"
rs.PageSize = 25
rs.CursorLocation = 3
rs.Open sql,conn,0,2,1
pre = true
last = true
page = trim(Request.QueryString("page"))
if len(page) = 0 then
intpage = 1
pre = false
else
if cint(page) =< 1 then
intpage = 1
pre = false
else
if cint(page) >= rs.PageCount then
intpage = rs.PageCount
last = false
else
intpage = cint(page)
end if
end if
end if
if not rs.eof then
rs.AbsolutePage = intpage
end if
%>
<div align="center">
<table width="766" height="34" border="0" cellpadding="1" cellspacing="0">
<tr class="tr_southidc">
<td><table width="766" height="34" border="0" cellpadding="1" cellspacing="0">
<tr class="back_southidc">
<td width="113"><div align="center">日期</div></td>
<td width="113"><div align="center">合计金额</div></td>
</tr>
<%
for i=1 to rs.PageSize
if not rs.EOF or not rs.BOF then exit for
%>
<tr class="tr_southidc">
<td><div align="center"><%=rs("rukushijian")%></div></td>
<td><div align="center"><%=rs("sumRkjagehe")%></div></td>
作者: lihui226 发布时间: 2011-06-24
if not rs.EOF or not rs.BOF then exit for?这句话好像有问题当有数据的时候跳出循环?
作者: ma1986 发布时间: 2011-06-24
你这样控制嘛
i=1
do while not rs.EOF
<tr class="tr_southidc">
<td><div align="center"><%=rs("rukushijian")%></div></td>
<td><div align="center"><%=rs("sumRkjagehe")%></div></td>
i=i+1
if i>25 then exit do
rs.movenext
loop
i=1
do while not rs.EOF
<tr class="tr_southidc">
<td><div align="center"><%=rs("rukushijian")%></div></td>
<td><div align="center"><%=rs("sumRkjagehe")%></div></td>
i=i+1
if i>25 then exit do
rs.movenext
loop
作者: ma1986 发布时间: 2011-06-24
应该是
if (rs.eof or rs.bof) then exit for
吧。
if (rs.eof or rs.bof) then exit for
吧。
作者: tcwsyt 发布时间: 2011-06-24
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28