小弟最近遇到个问题~写的一个网页,在本机上直接输入地址调试出现以下错误 错误类型: ADODB.Recordset (0x800A0BB9) 参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突。 /hhlq/111/fapiao/fpiao_list.asp, 第 78 行 但在Internet 信息服务里调试(直接点流览文件)却一切正常 到别人的机子上输入服务器的ip 也可以正常操作 这是什么原因请大家指教 代码如下这是fapiao.asp的代码是错误代码fpiao_list.asp的父框架 <%qx=trim(session("i")) xm=trim(session("user")) bm=trim(session("b")) %> <html> <head> <title>发票单</title> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312"> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="Cache-Control" content="no-cache, must-revalidate"> <meta http-equiv="expires" content="wed, 26 Feb 1997 08:21:57 GMT"> <link rel="stylesheet" href="../inc/test.css" type="text/css"> <script language="JavaScript" type="text/JavaScript"> <!-- function MM_reloadPage(init) { //reloads the window if Nav4 resized if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) { document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }} else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload(); } MM_reloadPage(true);
function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; }
function MM_showHideLayers() { //v6.0 var i,p,v,obj,args=MM_showHideLayers.arguments; for (i=0; i<(args.length-2); i+=3) if ((obj=MM_findObj(args[i]))!=null) { v=args[i+2]; if (obj.style) { obj=obj.style; v=(v=='show')?'visible':(v=='hide')?'hidden':v; } obj.visibility=v; } } function bmck(){ if (document.fenye.id.value==""){ alert('请选择您部门需要审核的记录!'); return false; } window.open("fpiaosh_viewb.asp?id=" + document.fenye.id.value,"jhmodi","width=810,height=480,resizable=no,scrollbars=no,statue=no,toolbar=no,menubar=no,location=no,left=150,top=80"); }
function xmck(){ if (document.fenye.id.value==""){ alert('请选择要审核的记录!'); return false; } window.open("fpiaosh_viewx.asp?id=" + document.fenye.id.value,"jhmodi","width=810,height=480,resizable=no,scrollbars=no,statue=no,toolbar=no,menubar=no,location=no,left=150,top=80"); }
function jlck(){ if (document.fenye.id.value==""){ alert('请选择要审核的记录!'); return false; } window.open("fpiaosh_viewj.asp?id=" + document.fenye.id.value,"jhmodi","width=810,height=480,resizable=no,scrollbars=no,statue=no,toolbar=no,menubar=no,location=no,left=150,top=80"); }
function jlck(){ if (document.fenye.id.value==""){ alert('请选择要审核的记录!'); return false; } window.open("fpiaosh_viewj.asp?id=" + document.fenye.id.value,"jhmodi","width=810,height=480,resizable=no,scrollbars=no,statue=no,toolbar=no,menubar=no,location=no,left=150,top=80"); }
function ckmodi(){ if (document.fenye.id.value==""){ alert('请选择要修改的记录!'); return false; }
if (document.fenye.user.value!="<%=session("username")%>") { alert('请不要修改他人的记录!'); return false; }
window.open("fpiao_modi.asp?id=" + document.fenye.id.value,"jhmodi","width=810,height=450,resizable=no,scrollbars=no,statue=no,toolbar=no,menubar=no,location=no,left=150,top=80"); }
function ckdel(){ if (document.fenye.id.value=="") { alert('请选择要删除的记录!'); return false; }
if (document.fenye.user.value!="<%=session("username")%>") { alert('请不要删除他人的记录!'); return false; }
if (confirm('你确定要删除吗?')){ delrow.location="fpiao_del.asp?id=" + document.fenye.id.value+"&bill_bh="+document.fenye.bill_bh.value; } }
function MM_openBrWindow(theURL,winName,features) { //v2.0 window.open(theURL,winName,features); } //--> </script> </head>
<body bgcolor="menu" text="#000000" scroll="no" style="border:0; " onclick="MM_showHideLayers('cz','','hide','cz2','','hide','cx','','hide','cx2','','hide')"> <table width="100%" height="100%" border="0" align="center" cellpadding="0" cellspacing="0"> <tr background="../images/bjin.gif"> <td width="1009" height="15" colspan="7" background="../images/bjin.gif" ><table width="100%" border="0" cellspacing="0"> <tr> <td width="1%"><div align="center"><img src="../images/s.gif" width="3" height="18"></div></td> <td width="20" onMouseOver=this.className='button2' onMouseDown=this.className='button4' onMouseOut=this.className=''><div align="center"><a href="javascript:window.close();"><img src="../images/tc.gif" width="49" height="19" border="0"></a></div></td> <td width="20" onMouseOver=this.className='button2' onMouseDown=this.className='button4' onMouseOut=this.className=''><div align="center"><img src="../images/sx.gif" width="53" height="19" onClick="window.location.reload();"></div></td> <td width="1" background="../images/su.gif" ></td> <% if qx="用户" then %> <td width="100" onMouseOver=this.className='button2' onMouseDown=this.className='button4' onMouseOut=this.className='' onClick="MM_openBrWindow('fpiao_add.asp','opener','width=750,height=400')"> <div align="center"><img src="../images/bmdd.gif" width="74" height="19" border="0"> </div></td> <td width="90" onclick="ckdel();" onMouseOver=this.className='button2' onMouseDown=this.className='button4' onMouseOut=this.className=''> <div align="center"><img src="../images/dr.gif" width="74" height="19"></div></td> <td width="90" onMouseOver=this.className='button2' onMouseDown=this.className='button4' onMouseOut=this.className='' onclick="ckmodi();"> <div align="center"><img src="../images/vr.gif" width="74" height="19"></div></td> <%end if%> <td width="1" background="../images/su.gif" ></td> <td width="20" onMouseOver=this.className='button2' onMouseDown=this.className='button4' onMouseOut=this.className=''><div align="center"><img src="../images/syy.gif" width="45" height="19" onclick="fy('1');"></div></td> <td width="20" onMouseOver=this.className='button2' onMouseDown=this.className='button4' onMouseOut=this.className=''><div align="center"><img src="../images/xyy.gif" width="46" height="19" onclick="fy('2');" ></div></td> <td width="1" background="../images/su.gif" ></td> <%if qx="部门" or qx="管理员" then %> <td width="100" onMouseOver=this.className='button2' onMouseDown=this.className='button4' onMouseOut=this.className='' onClick="bmck();"> <div align="center"> <img src="../images/bmsh.png" width="74" height="19" border="0"> </div></td> <%end if%> <td width="1" background="../images/su.gif" ></td> <%if qx="项目经理" or qx="管理员" then %> <td width="100" onMouseOver=this.className='button2' onMouseDown=this.className='button4' onMouseOut=this.className='' onClick="xmck();"> <div align="center"><img src="../images/xmsh.png" width="74" height="19" border="0"> </div></td> <%end if%> <td width="1" background="../images/su.gif" ></td> <%if qx="经理" or qx="管理员" then %> <td width="100" onMouseOver=this.className='button2' onMouseDown=this.className='button4' onMouseOut=this.className='' onClick="jlck();"> <div align="center"><img src="../images/jlsh.png" width="74" height="19" border="0"> </div></td> <%end if%> <%if qx="财务" or qx="管理员" then %> <td width="100" onMouseOver=this.className='button2' onMouseDown=this.className='button4' onMouseOut=this.className='' > <div align="center"><a href="jh_search.asp?billKind=已审核"><img src="../images/cwbz.png" width="74" height="19" border="0"></a> </div></td> <%end if%> <%if qx="用户" then %> <td width="100" onMouseOver=this.className='button2' onMouseDown=this.className='button4' onMouseOut=this.className='' > <div align="center"><a href="jh_searchy.asp?billKind=已审核"><img src="../images/yhcx.png" width="74" height="19" border="0"></a> </div></td> <%end if%> <%if qx="项目经理" or qx="经理" then %> <td width="100" onMouseOver=this.className='button2' onMouseDown=this.className='button4' onMouseOut=this.className='' > <div align="center"><a href="jh_searchj.asp?billKind=已审核"><img src="../images/jlcx.png" width="74" height="19" border="0"></a> </div></td> <%end if%> <%if qx="部门" then %> <td width="100" onMouseOver=this.className='button2' onMouseDown=this.className='button4' onMouseOut=this.className='' > <div align="center"><a href="jh_searchb.asp?billKind=已审核"><img src="../images/bmcx.png" width="74" height="19" border="0"></a> </div></td> <%end if%> <td><form action="" method="post" name="fenye" id="fenye"> <input name="page" type="hidden" id="page"> <input name="payoffdate" type="hidden" id="payoffdate"> <input name="bm" type="hidden" id="bm"> <input name="id" type="hidden" id="id"> <input name="bill_bh" type="hidden" id="bill_bh"> <input name="user" type="hidden" id="user"> </form> <script language="JavaScript"> function fy(kk){ var curpage=document.fenye.page.value; var cpage if (kk=="1" ) {cpage=parseInt(curpage)-1;} if (kk=="2" ) {cpage=parseInt(curpage)+1;} window.oa_main.location="fpiao_list.asp?curpage=" + cpage; } </script> </td> </tr> </table></td> </tr> <tr> <td width="100%" colspan="7" align="center"> <iframe name="oa_main" id="oa_main" style="width:100%; height:expression(body.offsetHeight-32);" src="fpiao_list.asp" scrolling="no"></iframe></td> <iframe name="delrow" id="delrow" width="0" height="0" ></iframe> </tr> </table> </body> </html>
[此贴子已经被作者于2005-2-19 13:56:10编辑过]