搜索
编程论坛 → WEB开发 → 『 ASP技术论坛 』 → 郁闷中～
标题：郁闷中～
只看楼主
hhlq04
Rank: 1
等　级：新手上路
帖　子：9
专家分：0
注　册：2004-10-1
楼主
 问题点数：0 回复次数：4 
郁闷中～

小弟最近遇到个问题～写的一个网页，在本机上直接输入地址调试出现以下错误 错误类型： 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编辑过]

搜索更多相关主题的帖子: 服务器　list　fapiao　fpiao　
2005-02-19 13:33
hhlq04
Rank: 1
等　级：新手上路
帖　子：9
专家分：0
注　册：2004-10-1
第 2 楼
 得分:0 

这个就是出错代码 fpiao_list.asp <!--#include file="conn.asp"--> <% qx=trim(session("i")) xm=trim(session("user")) bm=trim(session("b")) %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>发票单</title> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <link href="../inc/body.css" rel="stylesheet" type="text/css"> <script language="JavaScript"> function SwitchMenu(obj,ckid,bill_bh,user){ if(document.getElementById){ var el = document.getElementById(obj); var ar = document.getElementById("masterdiv").getElementsByTagName("tr"); //DynamicDrive.com change for (var i=0; i<ar.length; i++){ ar[i].className= ""; } el.className= "over"; } top.document.fenye.id.value=ckid; top.document.fenye.bill_bh.value=bill_bh; top.document.fenye.user.value=user; } function ckview(id){ window.open("fpiao_view.asp?id="+id,"_blank","height=500,width=800,resizable=no,scrollbars=no,statue=no,toolbar=no,menubar=no,location=no,left=150,top=80"); } </script> </head>

<body> <table width="100%" height="24" border="0" cellspacing="0"> <tr align="center" class="borderon"> <td width="7%" class="borderon">单据编号</td> <td width="7%" class="borderon">付款金额</td> <td width="8%" class="borderon"> <div align="center"> 经手人</div></td> <td width="7%" class="borderon"> <div align="center"> 录单时间</div></td> <td width="21%" class="borderon">备注</td> </tr> </table> <table id="masterdiv" width="100%" border="0" cellspacing="1" bgcolor="#E8E8E8"> <% dim curpage if request("curpage")="" then curpage=1 else curpage=request("curpage") end if if not isnumeric(trim(request("curpage"))) then curpage=1 end if if cint(curpage)=0 then curpage=1 end if const numperpage=36 set rs=server.createobject("adodb.recordset") if qx="用户" then sql="select * from yw_fpiao where username='"&xm&"'" elseif qx="部门" then sql="select * from yw_fpiao where (Torl='0' or TorL='部门同意') and bm='"&bm&"' order by maketabdate desc" elseif qx="项目经理" then sql="select * from yw_fpiao where Torl='部门同意' or TorL='项目经理同意' order by maketabdate desc" elseif qx="经理" then sql="select * from yw_fpiao where TorL='项目经理同意' or TorL='经理同意' order by maketabdate desc" elseif qx="财务" then sql="select * from yw_fpiao where TorL='财务同意' or TorL='经理同意' order by maketabdate desc" end if response.write sql response.write xm response.write qx rs.open sql,conn,1,1 if rs.eof then response.write "<tr><td><br></br><center>暂无数据，请添加！</center><br></br></td></tr>" end if if not rs.eof then response.Write("<script>top.document.fenye.page.value='"&curpage&"';</script>") rs.pagesize=numperpage dim totalpages totalpages=rs.pagecount if cint(curpage)>cint(totalpages) then curpage=totalpages end if rs.absolutepage=curpage end if dim count count=0 i=1 do while not rs.eof and count<numperpage tor=rs("Torl") if tor="0" then %> <tr id=<%=i%> onClick="SwitchMenu('<%=i%>','<%=trim(rs("id"))%>','<%=trim(rs("bill_bh"))%>','<%=trim(rs("username"))%>');" bgcolor="#FFFFFF" onDblClick="ckview('<%=trim(rs("id"))%>')"> <%elseif tor="部门同意" then %> <tr id=<%=i%> onClick="SwitchMenu('<%=i%>','<%=trim(rs("id"))%>','<%=trim(rs("bill_bh"))%>','<%=trim(rs("username"))%>');" bgcolor="#0099CC" onDblClick="ckview('<%=trim(rs("id"))%>')"> <%elseif tor="项目经理同意" then %> <tr id=<%=i%> onClick="SwitchMenu('<%=i%>','<%=trim(rs("id"))%>','<%=trim(rs("bill_bh"))%>','<%=trim(rs("username"))%>');" bgcolor="#00CC99" onDblClick="ckview('<%=trim(rs("id"))%>')"> <%elseif tor="经理同意" then %> <tr id=<%=i%> onClick="SwitchMenu('<%=i%>','<%=trim(rs("id"))%>','<%=trim(rs("bill_bh"))%>','<%=trim(rs("username"))%>');" bgcolor="#0000FF" onDblClick="ckview('<%=trim(rs("id"))%>')"> <%elseif tor="财务同意" then %> <tr id=<%=i%> onClick="SwitchMenu('<%=i%>','<%=trim(rs("id"))%>','<%=trim(rs("bill_bh"))%>','<%=trim(rs("username"))%>');" bgcolor="#33CC00" onDblClick="ckview('<%=trim(rs("id"))%>')"> <%end if%> <td width="7%"><div align="center"><%=trim(rs("bill_bh"))%></div></td> <td width="7%"><div align="center"><%=trim(rs("paymoney"))%></div></td> <td width="8%"><div align="center"><%=trim(rs("jingsren"))%></div></td> <td width="7%"><div align="center"><%=trim(rs("maketabdate"))%></div></td> <td width="21%"><div align="center"><%=trim(rs("bz"))%></div></td> </tr> <% rs.movenext i=i+1 count=count+1 loop rs.close set rs=nothing %> </table> <table width="398" border="0" align="center"> <tr> <td width="392" height="38"> <div align="center"><font color="#666666">第<%=curpage%>页/共<%=totalpages%>页</font></div></td> </tr> </table> </body> </html>

[此贴子已经被作者于2005-2-19 17:17:42编辑过]


2005-02-19 13:35
zero_one
Rank: 1
等　级：新手上路
帖　子：72
专家分：0
注　册：2005-2-12
第 3 楼
 得分:0 
我才郁闷.78行,你不知道知道标出来嘛

---------------------------------------------- 我郁闷，因为学得差劲。
2005-02-19 14:55
shade
Rank: 1
等　级：新手上路
帖　子：16
专家分：0
注　册：2005-2-12
第 4 楼
 得分:0 
哇
这么多啊
我要看晕了

如果你有兴趣的话，我们一起学习一起讨论 QQ：66035018 E-mail:shadedir@ zzrong147@.cn
2005-02-19 16:01
hhlq04
Rank: 1
等　级：新手上路
帖　子：9
专家分：0
注　册：2004-10-1
第 5 楼
 得分:0 
不好意思～～是蓝色部分～～我觉得可能不是代码问题不知道你们遇到这样的问题没有～～我只是想，我也是第一次，会不是ie的cookies没传递过来呢，或是读取权限问题，盘的分区是fat的没有安全选项也不会存在IUSR_问题，～～session也没有失效我在自己的机子上怎么调试都是一样的结果～～只有在Internet 信息服务打开和在别的机子打开可以
总之我真的想不到什么好的解释哪位大哥的帮我以下，可能这只是部分代码～～哪个加下我qq我把他发过来看看～～，我的qq是７８０１６４８１

2005-02-19 17:09



参与讨论请移步原网站贴子：https://bbs.bccn.net/thread-12322-1-1.html




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

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