各位大虾:看看我的代码哪里出了问题? - ASP技术论坛

86j3b

等　级：新手上路
帖　子：43
专家分：0
注　册：2005-5-11

第 2 楼

得分:0

index.htm [CODE] <html>

</form> </body>

</html> [/CODE] sj.asp [CODE] <% hh=request.form("hh") mm=request.form("mm") set conn=server.createobject("adodb.connection") conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("dat/tj.mdb") exec="select * from hhhm where hh='"&hh&"' and mm='"&mm&"'" set rs=server.createobject("adodb.recordset") rs.open exec,conn,1,2 %> <html>

<body>

<table border="1" cellpadding="0" cellspacing="5" width="100%" height="17" bordercolor="#FFFFFF" background="photo/back011.gif"> <tr> <%do while not rs.eof%> <td width="50%" bgcolor="#FFFFFF" height="11" bordercolor="#FFFFFF" background="photo/back016.gif"><%=rs("hm")%><%=rs("yue")%><font size="5" face="华文新魏">月份现金统计表</font></td> <% rs.movenext loop

rs.close conn.close set rs=nothing set conn=nothing %> <td width="50%" height="11"> <table border="0" cellpadding="0" cellspacing="5" width="100%" height="40"> <td width="20%" valign="middle" align="center" bgcolor="#000000" bordercolor="#FFFFFF" height="34"><font color="#FFFFFF">修改密码</font></td> <td width="20%" valign="middle" align="center" bgcolor="#000000" bordercolor="#FFFFFF" height="34"><font color="#FFFFFF">使用说明</font></td> <td width="20%" valign="middle" align="center" bgcolor="#000000" bordercolor="#FFFFFF" height="34">　</td> <td width="20%" valign="middle" align="center" bgcolor="#000000" bordercolor="#FFFFFF" height="34">　</td> <td width="20%" valign="middle" align="center" bgcolor="#000000" bordercolor="#FFFFFF" height="34"><font color="#FFFFFF"><a href="http://192.168.0.1/index.htm">退出</a></font></td>

</table> </td> </tr> </table> <hr> <table border="0" cellpadding="0" cellspacing="5" width="7%"> </table> <table border="0" cellpadding="0" cellspacing="5" width="100%" background="photo/back001.gif"> <tr> <td width="13%" valign="top"> <table border="0" cellpadding="0" cellspacing="5" width="99%"> <tr> <td width="100%" valign="top" align="center"><a href="#">输入</a></td> </tr> <tr> <td width="100%" valign="top" align="center">查询</td> </tr> <tr> <td width="100%" valign="top" align="center">修改</td> </tr> <tr> <td width="100%" valign="top" align="center">打印</td> </tr> <tr> <td width="100%" valign="top" align="center">并表</td> </tr> <tr> <td width="100%" valign="top" align="center"></td> </tr> <tr> <td width="100%" valign="top" align="center"></td> </tr> </table> </td> <td width="82%"> <form method="POSt" action="http://192.168.0.1/sr.asp"> <p align="center">日期： <select size="1" name="rq"> <option value="01">1</option> <option value="02">2</option> <option value="03">3</option> <option value="04">4</option> <option value="05">5</option> <option value="06">6</option> <option value="07">7</option> <option value="08">8</option> <option value="09">9</option> <option value="10">10</option> <option value="11">11</option> <option value="12">12</option> <option value="13">13</option> <option value="14">14</option> <option value="15">15</option> <option value="16">16</option> <option value="17">17</option> <option value="18">18</option> <option value="19">19</option> <option value="20">20</option> <option value="21">21</option> <option value="22">22</option> <option value="23">23</option> <option value="24">24</option> <option value="25">25</option> <option value="26">26</option> <option value="27">27</option> <option value="28">28</option> <option value="29">29</option> <option value="30">30</option> <option value="31">31</option> </select></p> <p align="center">一.商品销售收入             <input type="text" name="t121110000" size="20" value="0"></p> <p align="center">二.服务业收入               <input type="text" name="t121120000" size="20" value="0"></p> <p align="center">三.税款收入                 <input type="text" name="t121130000" size="20" value="0"></p> <p align="center">四.城乡个体经营收入         <input type="text" name="t121140000" size="20" value="0"></p> <p align="center">五.储蓄存款收入             <input type="text" name="t121150000" size="20" value="0"></p> <p align="center">六.其它金融机构收入         <input type="text" name="t121160000" size="20" value="0"></p> <p align="center">七.居民归还贷款收入         <input type="text" name="t121170000" size="20" value="0"></p> <p align="center">八.汇兑收入                 <input type="text" name="t121180000" size="20" value="0"></p> <p align="center">九.有价单证收入             <input type="text" name="t121190000" size="20" value="0"></p> <p align="center">十.其它收入                 <input type="text" name="t1211A0000" size="20" value="0"></p> <p align="center">  其中:兑换外币收入         <input type="text" name="t1211A1000" size="20" value="0"></p> <p align="center">   收入合计              <input type="text" name="t121100000" size="20" value="0"></p> <p align="center"> 内部现金收入               <input type="text" name="t121200000" size="20" value="0"></p> <p align="center"> 同业往来收入               <input type="text" name="t121300000" size="20" value="0"></p> <p align="center"> 由人行发行库领取现金       <input type="text" name="t121400000" size="20" value="0"></p> <p align="center"> 由银行(人行)业务库领取现金<input type="text" name="t121500000" size="20" value="0"></p> <p align="center"> 信用社(其它银行)交存现金   <input type="text" name="t121600000" size="20" value="0"></p> <p align="center"> 前期业务库存               <input type="text" name="t121700000" size="20" value="0"></p> <p align="center">  收入总计               <input type="text" name="t121000000" size="20" value="0"></p> <p align="center">一.工资性支出               <input type="text" name="t122110000" size="20" value="0"></p> <p align="center"> 1.国家工资及奖金支出       <input type="text" name="t122111000" size="20" value="0"></p> <p align="center"> 2.国家对个人其它支出       <input type="text" name="t122112000" size="20" value="0"></p> <p align="center"> 3.部队存款支出             <input type="text" name="t122113000" size="20" value="0"></p> <p align="center"> 4.其它单位工资性支出       <input type="text" name="t122114000" size="20" value="0"></p> <p align="center">二.农副产品采购支出         <input type="text" name="t122120000" size="20" value="0"></p> <p align="center">三.工矿及其它产品采购支出   <input type="text" name="t1221B0000" size="20" value="0"></p> <p align="center">四.行政企事业管理费支出     <input type="text" name="t122130000" size="20" value="0"></p> <p align="center">五.城乡个体经营支出         <input type="text" name="t122140000" size="20" value="0"></p> <p align="center">六.储蓄存款支出             <input type="text" name="t122150000" size="20" value="0"></p> <p align="center">七.其它金融机构支出         <input type="text" name="t122160000" size="20" value="0"></p> <p align="center">八.居民提取贷款支出         <input type="text" name="t122170000" size="20" value="0"></p> <p align="center">九.汇兑支出                 <input type="text" name="t122180000" size="20" value="0"></p> <p align="center">十.有价证券支出             <input type="text" name="t122190000" size="20" value="0"></p> <p align="center">十一.其它支出               <input type="text" name="t1221A0000" size="20" value="0"></p> <p align="center">  支出合计               <input type="text" name="t122100000" size="20" value="0"></p> <p align="center"> 内部现金支出               <input type="text" name="t122200000" size="20" value="0"></p> <p align="center"> 同业往来支出               <input type="text" name="t122300000" size="20" value="0"></p> <p align="center"> 交回人行发行库现金         <input type="text" name="t122400000" size="20" value="0"></p> <p align="center"> 交回银行(人行)业务库现金   <input type="text" name="t122500000" size="20" value="0"></p> <p align="center"> 信用社(其它银行)支取现金   <input type="text" name="t122600000" size="20" value="0"></p> <p align="center"> 本期业务库存               <input type="text" name="t122700000" size="20" value="0"></p> <p align="center">   支出总计              <input type="text" name="t122000000" size="20" value="0"></p> <p align="center"> 投放(+),回笼(-)            <input type="text" name="t123100000" size="20" value="0"></p> <p align="center"> 附报项目:代发工资          <input type="text" name="t123200000" size="20" value="0"></p>

<p align="center"><input type="submit" value="提交" name="B1"><input type="reset" value="全部重写" name="B2"></p> </form> </td> <td width="5%"></td> </tr> <tr> <td width="13%" valign="top"></td> <td width="82%"></td> <td width="5%"></td> </tr> </table> </body> </html> [/CODE] sr.asp [CODE] <% set conn=server.createobject("adodb.connection") conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("dat/tj.mdb") rq=request.form("rq") t121110000=request.form("t121110000") t121120000=request.form("t121120000") t121130000=request.form("t121130000") t121140000=request.form("t121140000") t121150000=request.form("t121150000") t121160000=request.form("t121160000") t121170000=request.form("t121170000") t121180000=request.form("t121180000") t121190000=request.form("t121190000") t1211A0000=request.form("t1211A0000") t1211A1000=request.form("t1211A1000") t121200000=request.form("t121200000") t121300000=request.form("t121300000") t121400000=request.form("t121400000") t121500000=request.form("t121500000") t121600000=request.form("t121600000") t121700000=request.form("t121700000") t122111000=request.form("t122111000") t122112000=request.form("t122112000") t122113000=request.form("t122113000") t122114000=request.form("t122114000") t122120000=request.form("t122120000") t1221B0000=request.form("t1221B0000") t122130000=request.form("t122130000") t122140000=request.form("t122140000") t122150000=request.form("t122150000") t122160000=request.form("t122160000") t122170000=request.form("t122170000") t122180000=request.form("t122180000") t122190000=request.form("t122190000") t1221A0000=request.form("t1221A0000") t122200000=request.form("t122200000") t122300000=request.form("t122300000") t122400000=request.form("t122400000") t122500000=request.form("t122500000") t122600000=request.form("t122600000") t122700000=request.form("t122700000") t123100000=request.form("t123100000") t123200000=request.form("t123200000")

exec="insert into sj(rq,t121110000,t121120000,t121130000,t121140000,t121150000,t121160000,t121170000,t121180000,t121190000,t1211A0000,t1211A1000,t121200000,t121300000,t121400000,t121500000,t121600000,t121700000,t122111000,t122112000,t122113000,t122114000,t122120000,t1221B0000,t122130000,t122140000,t122150000,t122160000,t122170000,t122180000,t122190000,t1221A0000,t122200000,t122300000,t122400000,t122500000,t122600000,t122700000,t123100000,t123200000)values('"&rq&"',"&t121110000&","&t121120000&","&t121130000&","&t121140000&"','"&t121150000&","&t121160000&","&t121170000&","&t121180000&","&t121190000&","&t1211A0000&","&t1211A1000&","&t121200000&","&t121300000&","&t121400000&","&t121500000&","&t121600000&","&t121700000&","&t122111000&","&t122112000&","&t122113000&","&t122114000&","&t122120000&","&t1221B0000&","&t122130000&","&t122140000&","&t122150000&","&t122160000&","&t122170000&","&t122180000&","&t122190000&","&t1221A0000&","&t122200000&","&t122300000&","&t122400000&","&t122500000&","&t122600000&","&t122700000&","&t123100000&","&t123200000&")" conn.execute exec conn.close set conn=nothing response.write "记录添加成功!" %> [/CODE] 运行结果:

技术信息（用于支持人员）

错误类型： Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 '0','0' 中。 /sr.asp, 第 46 行
浏览器类型： Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
网页： POST 593 ??? /sr.asp
POST Data: rq=01&t121110000=0&t121120000=0&t121130000=0&t121140000=0&t121150000=0&t121160000=0&t121170000=0&t121180000=0&t121190000=0&t1211A0000=0&t1211A1000=0&t121100000=0&t121200000=0&t121300000=0&t121400000=0 . . .
时间： 2005年5月27日, 22:44:45
详细信息： Microsoft 支持

2005-05-27 22:58

tyang

等　级：新手上路
帖　子：216
专家分：0
注　册：2004-9-16

第 4 楼

得分:0

我的天呀晕了

我的网站" target="_blank">http://www. 欢迎加入网站设计交流群：17222128

2005-05-28 08:44