| 网站首页 | 业界新闻 | 群组 | 交易 | 人才 | 下载频道 | 博客 | 代码贴 | 在线编程 | 编程论坛
共有 399 人关注过本帖
标题:关于ASP调取mdb数据库数据
只看楼主 加入收藏
haoliang_che
Rank: 1
等 级:新手上路
帖 子:2
专家分:0
注 册:2018-12-22
结帖率:0
  已结贴   问题点数:20  回复次数:2   
关于ASP调取mdb数据库数据
<table border="1" cellspacing="0" cellpadding="0" class="table" width="100%" style="white-space:nowrap">
      <tr>
          <td width="80" align="center">序号</td>
        <td width="100px" align="center">任务编号</td>
        <td width="150px" align="center">状态</td>
        <td width="100px" align="center">投产日期</td>
        <td width="100px" align="center">交付日期</td>
        <td width="600px" align="center">
          <form name="kh" id="kh">
            <select name="menu1" onchange="MM_jumpMenu('mainFrame',this,0)" style="border:none; ">
              <option style="text-align:center">客户名称</option>
            </select>
          </form>
        </td>
        <td width="200px" align="center">产品名称</td>
        <td width="200px" align="center">产品型号</td>
        <td width="80px" align="center">单位</td>
        <td width="100px" align="center">数量</td>
        <td width="150px" align="center">清单</td>
        <td width="100px" align="center">合同编号</td>
        <td width="150px" align="center">合同内容</td>
        <td width="150px" align="center">报价金额</td>
        <td width="150px" align="center">合同金额</td>
        <td width="150px" align="center">开票金额</td>
        <td width="150px" align="center">已付金额</td>
        <td width="400px" align="center">备注</td>
        <td width="80px" align="center" style="border:none">&nbsp;</td>
        <td width="80px" align="center" style="border:none">&nbsp;</td>
      </tr>
      <%
       for i=1 to rsc.recordcount step 1
      %>
      <tr>
        <td align="center"><%=i%></td>
        <td align="center"><%=rsc("rwbh")%></td>
        <td align="center"><%=rsc("zt")%></td>
        <td align="center"><%=rsc("tcrq")%></td>
        <td align="center"><%=rsc("jfrq")%></td>
        <td align="center"><%=rsc("khmc")%></td>
        <td align="center"><%=rsc("cp")%></td>
        <td align="center"><%=rsc("xh")%></td>
        <td align="center"><%=rsc("dw")%></td>
        <td align="center"><%=formatnumber(rsc("sl"),2)%></td>
        <td align="center">
        <%
        if rsc("qd")="详见明细" then
           response.Write"<a href=../qd/" & rsc("rwbh") & ".pdf target=_blank>" & rsc("qd") & "</a>"
        else
           response.Write"无"
        end if
        %>
        </td>
        <td align="center"><%=rsc("htbh")%></td>
        <td align="center"><a href="../qd/<%=rsc("rwbh")%>.pdf" target="_blank"><%=rsc("htnr")%></a></td>
        <td align="center"><%=formatnumber(rsc("bjje"),2,-1)%></td>
        <td align="center"><%=formatnumber(rsc("htje"),2,-1)%></td>
        <td align="center">
            <%
                set rs=server.createobject("adodb.recordset")
                sql="select sum(kpje) as kp from kpmx where rwbh='" & rsc("rwbh") & "'"
                rs.open sql,conn,1,1
                response.write "<a href=kpcx.asp?n=" & rsc("rwbh") & "> " & formatnumber(rs("kp"),2,-1) & "</a>"
                rs.close            
            %>
        </td>
        <td align="center">
            <%
                set rs=server.createobject("adodb.recordset")
                sql="select sum(dkje) as dk from dkmx where rwbh='" & rsc("rwbh") & "'"
                rs.open sql,conn,1,1
                response.write "<a href=dkcx.asp?n=" & rsc("rwbh") & "> " & formatnumber(rs("dk"),2,-1) & "</a>"
                rs.close            
            %>
        </td>
        <td><%=rsc("bz")%></td>
        <td width="80px" align="center" style="border:none"><a href="#">更改</a></td>
        <td width="80px" align="center" style="border:none"><a href="#">删除</a></td>
      </tr>
      <%
       rsc.movenext
       next
      %>
    </table>
这段代码,我在下载的简易服务器测试没有问题,可以调出数据。可是在win7下安装了IIS7.5,然后进行测试这里就读不出数据,请问大神们这是什么问题呢?谢谢!!
2018-12-22 15:20
haoliang_che
Rank: 1
等 级:新手上路
帖 子:2
专家分:0
注 册:2018-12-22
  得分:0 
高手们难道都在休息吗
2018-12-22 15:34
icecool
Rank: 9Rank: 9Rank: 9
等 级:贵宾
威 望:20
帖 子:1203
专家分:1309
注 册:2005-3-14
  得分:20 
那应该是你IIS的问题,先试试iis能否正常工作

loading...
2018-12-23 10:48







关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.048143 second(s), 8 queries.
Copyright©2004-2019, BCCN.NET, All Rights Reserved