各位大虾:看看我的代码哪里出了问题?
各位大虾:看看我的代码哪里出了问题?
index.htm [CODE] <html>
<head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <meta name="GENERATOR" content="Microsoft FrontPage 4.0"> <meta name="ProgId" content="FrontPage.Editor.Document"> <title>New Page 1</title> </head> <body background="photo/030904xingzuo03.jpg">
<p align="center"><span lang="EN-US" style="font-size:10.5pt;mso-bidi-font-size: 12.0pt;font-family:"Times New Roman";mso-fareast-font-family:宋体;mso-font-kerning: 1.0pt;mso-ansi-language:EN-US;mso-fareast-language:ZH-CN;mso-bidi-language: AR-SA"> <img border="0" src="photo/1.JPG" width="20" height="61"></span></p> <p align="center"><span lang="EN-US" style="font-size:10.5pt;mso-bidi-font-size: 12.0pt;font-family:"Times New Roman";mso-fareast-font-family:宋体;mso-font-kerning: 1.0pt;mso-ansi-language:EN-US;mso-fareast-language:ZH-CN;mso-bidi-language: AR-SA"><img src="photo/new_pa1.gif" alt="嘉祥县支行现金统计系统" v:shapes="_x0000_i1025" width="541" height="100"></span></p> <p align="center"><img border="0" src="photo/1.JPG" width="30" height="41"></p> <form method="POST" action="http://192.168.0.1/sj.asp"> <p align="center"><font color="#CCFF33">行号 </font><font color="#FFFF99"> </font><font color="#00FFFF"> </font><input type="text" name="hh" size="8"></p> <p align="center"><font color="#CCFF33">密码</font><font color="#008000"> </font><input type="password" name="mm" size="8"></p>
<p align="center"><input type="submit" value="提交" name="B1"> <input type="reset" value="重写" name="B2">
</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>
<head> <meta http-equiv="Content-Language" content="zh-cn"> <meta http-equiv="Content-type" content="text/html; charset=gb2312"> <meta name="GENERAtOR" content="Microsoft FrontPage 4.0"> <meta name="ProgId" content="FrontPage.Editor.Document"> <title>New Page 1</title> </head>
<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">一.商品销售收入 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t121110000" size="20" value="0"></p> <p align="center">二.服务业收入 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t121120000" size="20" value="0"></p> <p align="center">三.税款收入 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t121130000" size="20" value="0"></p> <p align="center">四.城乡个体经营收入 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t121140000" size="20" value="0"></p> <p align="center">五.储蓄存款收入 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t121150000" size="20" value="0"></p> <p align="center">六.其它金融机构收入 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t121160000" size="20" value="0"></p> <p align="center">七.居民归还贷款收入 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t121170000" size="20" value="0"></p> <p align="center">八.汇兑收入 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t121180000" size="20" value="0"></p> <p align="center">九.有价单证收入 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t121190000" size="20" value="0"></p> <p align="center">十.其它收入 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t1211A0000" size="20" value="0"></p> <p align="center"> 其中:兑换外币收入 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t1211A1000" size="20" value="0"></p> <p align="center"> 收 入 合 计 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t121100000" size="20" value="0"></p> <p align="center"> 内部现金收入 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t121200000" size="20" value="0"></p> <p align="center"> 同业往来收入 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t121300000" size="20" value="0"></p> <p align="center"> 由人行发行库领取现金 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t121400000" size="20" value="0"></p> <p align="center"> 由银行(人行)业务库领取现金<!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --><input type="text" name="t121500000" size="20" value="0"></p> <p align="center"> 信用社(其它银行)交存现金 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t121600000" size="20" value="0"></p> <p align="center"> 前期业务库存 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t121700000" size="20" value="0"></p> <p align="center"> 收 入 总 计 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t121000000" size="20" value="0"></p> <p align="center">一.工资性支出 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t122110000" size="20" value="0"></p> <p align="center"> 1.国家工资及奖金支出 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t122111000" size="20" value="0"></p> <p align="center"> 2.国家对个人其它支出 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t122112000" size="20" value="0"></p> <p align="center"> 3.部队存款支出 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t122113000" size="20" value="0"></p> <p align="center"> 4.其它单位工资性支出 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t122114000" size="20" value="0"></p> <p align="center">二.农副产品采购支出 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t122120000" size="20" value="0"></p> <p align="center">三.工矿及其它产品采购支出 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t1221B0000" size="20" value="0"></p> <p align="center">四.行政企事业管理费支出 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t122130000" size="20" value="0"></p> <p align="center">五.城乡个体经营支出 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t122140000" size="20" value="0"></p> <p align="center">六.储蓄存款支出 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t122150000" size="20" value="0"></p> <p align="center">七.其它金融机构支出 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t122160000" size="20" value="0"></p> <p align="center">八.居民提取贷款支出 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t122170000" size="20" value="0"></p> <p align="center">九.汇兑支出 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t122180000" size="20" value="0"></p> <p align="center">十.有价证券支出 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t122190000" size="20" value="0"></p> <p align="center">十一.其它支出 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t1221A0000" size="20" value="0"></p> <p align="center"> 支 出 合 计 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t122100000" size="20" value="0"></p> <p align="center"> 内部现金支出 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t122200000" size="20" value="0"></p> <p align="center"> 同业往来支出 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t122300000" size="20" value="0"></p> <p align="center"> 交回人行发行库现金 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t122400000" size="20" value="0"></p> <p align="center"> 交回银行(人行)业务库现金 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t122500000" size="20" value="0"></p> <p align="center"> 信用社(其它银行)支取现金 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t122600000" size="20" value="0"></p> <p align="center"> 本期业务库存 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t122700000" size="20" value="0"></p> <p align="center"> 支 出 总 计 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t122000000" size="20" value="0"></p> <p align="center"> 投放(+),回笼(-) <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <input type="text" name="t123100000" size="20" value="0"></p> <p align="center"> 附报项目:代发工资 <!--webbot bot="Validation" S-Data-type="Integer" S-Number-Separators="x" --> <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 支持