注册 登录
编程论坛 → ASP技术论坛

业主添加正常，但是修改就提示类型不匹配

天蝎风 发布于 2010-11-17 12:04， 589 次点击
这是一个业主添加界面，输入资料提交成功，列表也显示正常，但是编辑后提交就出现以下错误：
Provider 错误 '80020005'

类型不匹配。

/1/yezhu/yezhu_modi.asp，行 280
==============================================源代码如下：
<%if request.Cookies("shiwei_username")="" then%>

<script language="javascript">top.location.href="../index.asp"</script>
<%   
  response.end
end if
%>
<!-- #include file="../conn2.asp" -->
<!-- #include file="../const.asp" -->
<html>
<head>
<title><%=gongsi%>-业主资料编辑</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../style/style.css" rel="stylesheet" type="text/css">
<style>body {background-color:#FFFFFF;}</style>
</HEAD>

<BODY>
<%if fla47="0" and request.Cookies("shiwei_id")<>"1" then%>
<br><center><img src="../images/note.gif" align="absmiddle">&nbsp;<font color="#FF0000">你不具备此权限，请与管理员联系！</font></center>
<%   
  response.end
end if
%>
<%if request("hid1")="" then%>  
<script language="javascript">
function check()
{
if (document.form1.username.value==""||document.form1.fanghao.value=="")
{
alert("有*号的必须填写！");
return false;
}
}
</script>
<%
sql="select * from yezhu where id="&request("id")
set rs=conn.execute(sql)
%>
<form name="form1">
  <input type="hidden" name="form" value="<%=request("form")%>">
  <input type="hidden" name="field" value="<%=request("field")%>">
  <input type="hidden" name="field2" value="<%=request("field2")%>">
  <input type="hidden" name="field3" value="<%=request("field3")%>">
  <input type="hidden" name="page" value="<%=request("page")%>">
  <input type="hidden" name="louyu" value="<%=request("louyu")%>">
  <input type="hidden" name="keyword" value="<%=request("keyword")%>">
  <input type="hidden" name="order1" value="<%=request("order1")%>">
  <input type="hidden" name="order2" value="<%=request("order2")%>">
  <input type="hidden" name="order3" value="<%=request("order3")%>">
  <input type="hidden" name="order4" value="<%=request("order4")%>">
  <input type="hidden" name="order5" value="<%=request("order5")%>">
  <input type="hidden" name="order6" value="<%=request("order6")%>">
  <input type="hidden" name="order7" value="<%=request("order7")%>">
  <input type="hidden" name="order8" value="<%=request("order8")%>">
  <input type="hidden" name="order9" value="<%=request("order9")%>">
  <input type="hidden" name="order10" value="<%=request("order10")%>">
  <input type="hidden" name="order11" value="<%=request("order11")%>">
  <input type="hidden" name="order12" value="<%=request("order12")%>">
  <input type="hidden" name="order13" value="<%=request("order13")%>">
  <input type="hidden" name="order14" value="<%=request("order14")%>">
  <input type="hidden" name="order15" value="<%=request("order15")%>">
  <table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#C4D8ED">
  <tr><td><img src="../images/r_1.gif" alt="" /></td>
  <td width="100%" background="../images/r_0.gif">
  <table cellpadding="0" cellspacing="0" width="100%">
  <tr><td>&nbsp;编辑业主资料(带*号的为必填项)</td>
  <td align="right">&nbsp;</td></tr>
  </table></td>
  <td><img src="../images/r_2.gif" alt="" /></td></tr>
  <tr>
  <td></td>
  <td><table align="center" cellpadding="4" cellspacing="1" class="toptable grid" border="1">
  <tr><td width="10%" height="30" align="right">所在小区：</td>
  <td width="40%" class="category">
  <%
if request.Cookies("shiwei_id")="1" or fla88="1" then
sql="select * from xiaoqu order by id"
set rs_xiaoqu=conn.execute(sql)
else
sql="select * from xiaoqu where instr(fuzeren,',"&request.Cookies("shiwei_id")&",')>0 order by id"
set rs_xiaoqu=conn.execute(sql)   
end if
if rs_xiaoqu.eof then
%>
  <script language="javascript">
alert("没有属于你管理的小区,请先添加小区！")
window.location.href="../yezhu/xiaoqu_add.asp"
</script>
  <%
  response.end
end if
%>
  <select name="xiaoqu<%=y%>">
  <%do while rs_xiaoqu.eof=false%>
  <option value="<%=rs_xiaoqu("id")%>"<%if rs_xiaoqu("id")=rs("xiaoqu") then%> selected="selected"<%end if%>><%=rs_xiaoqu("xiaoqu")%></option>
  <%
rs_xiaoqu.movenext
loop
%>
  </select>
  <td width="10%" height="30" align="right">楼宇单元：</td>
  <td width="40%" class="category">
<%
sql="select * from louyu order by id"
set rs_louyu=conn.execute(sql)
if rs_louyu.eof then
%>
  <script language="javascript">
alert("请先添加楼宇单元！")
window.location.href="louyu_add.asp"
</script>
  <%
response.end
end if
%>
  <select name="louyu">
  <%do while rs_louyu.eof=false%>
  <option value="<%=rs_louyu("id")%>"<%if rs_louyu("id")=rs("louyu") then%> selected="selected"<%end if%>><%=rs_louyu("louyu")%></option>
  <%
  rs_louyu.movenext
  loop
  %>
  </select></td></tr>
===========================与2楼连接
4 回复
#2
天蝎风2010-11-17 12:05
<tr><td align="right" height="30">房号：</td>
  <td class="category"><input type="text" name="fanghao" style="width:110px" value="<%=rs("fanghao")%>">&nbsp;
  <font color="#ff0000">*</font></td>
  <td height="30" align="right">业主姓名：</td>
  <td class="category"><input type="text" name="username" style="width:80px" value="<%=rs("username")%>">&nbsp;<font color="#ff0000">*</font></td></tr>
  <tr><td align="right" height="30">业主性别：</td>
  <td class="category">
  <input type="radio" name="xingbie" value="男"<%if rs("xingbie")="男" then%> checked="checked"<%end if%>>&nbsp;男&nbsp;&nbsp;
  <input type="radio" name="xingbie" value="女"<%if rs("xingbie")="女" then%> checked="checked"<%end if%>>&nbsp;女</td>
  <td align="right" height="30">联系电话：</td>
  <td class="category"><input type="text" name="tel" style="width:200px" value="<%=rs("tel")%>"></td></tr>
  <tr><td align="right" height="30">QQ：</td>
  <td class="category"><input type="text" name="qq" style="width:110px" value="<%=rs("qq")%>" onKeyUp="this.value=this.value.replace(/\D/g,'')" onafterpaste="this.value=this.value.replace(/\D/g,'')"></td>
  <td align="right" height="30">Email：</td>
  <td class="category"><input type="text" name="email" style="width:160px" value="<%=rs("email")%>"></td></tr>
  <tr><td align="right" height="30">家庭住址：</td>
  <td class="category"><input type="text" name="address" style="width:250px" value="<%=rs("address")%>"></td>
  <td align="right" height="30">身份证号：</td>
  <td class="category"><input type="text" name="zhenghao" style="width:160px" value="<%=rs("zhenghao")%>"></td></tr>
  <tr><td align="right" height="30">介绍人：</td>
  <td class="category">
  <%
if rs("jieshao")=0 then
  nowjieshao="无"
else
sql="select * from yezhu where id="&rs("jieshao")
set rs_jieshao=conn.execute(sql)
nowjieshao=rs_jieshao("username")
end if
%>
  <%=nowjieshao%></td>
  <td align="right" height="30">经办人：</td>
  <td class="category">
<%
if request.Cookies("shiwei_id")=1 then
  sql="select * from login order by bumen,id"
set rs_login=conn.execute(sql)
else
sql="select * from login where id="&request.Cookies("shiwei_id")
set rs_login=conn.execute(sql)   
end if
if rs_login.eof then
%>
  <script language="javascript">
alert("请先添加员工！")
window.location.href="../system/user_add.asp"
</script>
  <%
  response.end
else
%>
  <select name="jingban">
  <%do while rs_login.eof=false%>
  <option value="<%=rs_login("id")%>"<%if rs_login("id")=rs("jingban") then%> selected="selected"<%end if%>><%=rs_login("username")%> (<%=rs_login("gonghao")%>)</option>
  <%
  rs_login.movenext
loop
%>
  </select>
  <%end if%></td></tr>
  <tr><td align="right" height="30">业主生日：</td>
<td class="category"><input name="shengri" value="<%=rs("shengri")%>" readonly style="width:100px"><img src="../images/date.gif" align="absmiddle" style="cursor:pointer;" onClick="JavaScript:window.open('day.asp?form=form1&field=shengri&oldDate='+shengri.value,'','directorys=no,toolbar=no,status=no,menubar=no,scrollbars=no,resizable=no,width=250,height=170,top=470,left=520');">
 <select name="yinyang">
  <option value="阴"<%if rs("yinyang")="阴" then%> selected="selected"<%end if%>>阴历</option>
  <option value="阳"<%if rs("yinyang")="阳" then%> selected="selected"<%end if%>>阳历</option>
  </select></td>
  <td align="right" height="30">业主积分：</td>
  <td class="category"><input type="text" name="jifen" style="width:100px" value="<%=rs("jifen")%>" onKeyUp="value=value.replace(/[^\d.]/g,'')" onbeforepaste="clipboardData.setData('text',clipboardData.getData('text').replace(/[^\d.]/g,''))"></td></tr>
  <tr><td align="right" height="30">入住时间：</td>
  <td class="category"><input name="startdate" value="<%=rs("startdate")%>" readonly style="width:100px"><img src="../images/date.gif" align="absmiddle" style="cursor:pointer;" onClick="JavaScript:window.open('day.asp?form=form1&field=startdate&oldDate='+startdate.value,'','directorys=no,toolbar=no,status=no,menubar=no,scrollbars=no,resizable=no,width=250,height=170,top=150,left=590');"> </td>

  <td align="right" height="30">到期时间：</td>
  <td class="category"><input name="enddate" value="<%=rs("enddate")%>" readonly style="width:100px"><img src="../images/date.gif" align="absmiddle" style="cursor:pointer;" onClick="JavaScript:window.open('day.asp?form=form1&field=enddate&oldDate='+enddate.value,'','directorys=no,toolbar=no,status=no,menubar=no,scrollbars=no,resizable=no,width=250,height=170,top=150,left=590');"> </td></tr>
  <tr><td align="right" height="30">缴水费日：</td>
  <td class="category"><input name="shui" value="<%=rs("shui")%>" readonly style="width:100px"><img src="../images/date.gif" align="absmiddle" style="cursor:pointer;" onClick="JavaScript:window.open('day.asp?form=form1&field=shui&oldDate='+shui.value,'','directorys=no,toolbar=no,status=no,menubar=no,scrollbars=no,resizable=no,width=250,height=170,top=470,left=520');"></td>
  <td align="right" height="30">缴电费日：</td>
  <td class="category"><input name="dian" value="<%=rs("dian")%>" readonly style="width:100px"><img src="../images/date.gif" align="absmiddle" style="cursor:pointer;" onClick="JavaScript:window.open('day.asp?form=form1&field=dian&oldDate='+dian.value,'','directorys=no,toolbar=no,status=no,menubar=no,scrollbars=no,resizable=no,width=250,height=170,top=470,left=520');"></td></tr>
  <tr><td align="right" height="30">缴物管费日：</td>
  <td class="category"><input name="wuye" value="<%=rs("wuye")%>" readonly style="width:100px"><img src="../images/date.gif" align="absmiddle" style="cursor:pointer;" onClick="JavaScript:window.open('day.asp?form=form1&field=wuye&oldDate='+wuye.value,'','directorys=no,toolbar=no,status=no,menubar=no,scrollbars=no,resizable=no,width=250,height=170,top=470,left=520');"></td>
  <td align="right" height="30">缴其他费日：</td>
  <td class="category"><input name="qita" value="<%=rs("qita")%>" readonly style="width:100px"><img src="../images/date.gif" align="absmiddle" style="cursor:pointer;" onClick="JavaScript:window.open('day.asp?form=form1&field=qita&oldDate='+qita.value,'','directorys=no,toolbar=no,status=no,menubar=no,scrollbars=no,resizable=no,width=250,height=170,top=470,left=520');"></td></tr>
  <tr><td align="right" height="30">备注：</td>
  <td class="category"><textarea name="beizhu" cols="70" rows="4"><%=rs("beizhu")%></textarea></td></tr>
  <tr><td height="30">&nbsp;</td>
  <td class="category"><input type="submit" value="确认修改" onClick="return check()" class="button">&nbsp;&nbsp;&nbsp;&nbsp;<input type="reset" value="重置" class="button">&nbsp;&nbsp;&nbsp;&nbsp;<input type="button" value="放弃修改返回" onClick="window.history.go(-1)" class="button"><input type="hidden" name="hid1" value="ok"><input type="hidden" name="id" value="<%=request("id")%>"></td></tr>
</table></td>
 <td></td>
  </tr>
  <tr><td><img src="../images/r_4.gif" alt="" /></td>
  <td></td>
  <td><img src="../images/r_3.gif" alt="" /></td>
 </tr></table></form>
<%
else
nowqq=request("qq")
nowemail=request("email")
nowlouyu=request("louyu")
nowusername=request("username")
nowxingbie=request("xingbie")
nowtel=request("tel")
nowaddress=request("address")
nowzhenghao=request("zhenghao")
nowfanghao=request("fanghao")
nowjingban=request("jingban")
nowjifen=request("jifen")
nowbeizhu=request("beizhu")
nowstartdate=request("startdate")
nowenddate=request("enddate")
nowshengri=request("shengri")
nowyinyang=request("yinyang")
nowxiaoqu=request("xiaoqu")
nowshui=request("shui")
nowdian=request("dian")
nowwuye=request("wuye")
nowqita=request("qita")
sql="select * from yezhu where fanghao='"&nowfanghao&"' and id<>"&request("id")
set rs=conn.execute(sql)
if rs.eof=false then
%>
<script language="javascript">
alert("您输入的房号已经存在,请重新输入！")
window.history.go(-1)
</script>  
<%
  response.end
end if
set rs_login=conn.execute("select * from login where id="&nowjingban)
nowlogin=rs_login("username")
set rs=server.createobject("ADODB.RecordSet")
sql="select * from yezhu where id="&request("id")
rs.open sql,conn,1,3
rs("fanghao")=nowfanghao
rs("username")=nowusername
rs("xingbie")=nowxingbie
rs("tel")=nowtel
rs("address")=nowaddress
rs("zhenghao")=nowzhenghao
rs("jingban")=nowjingban
rs("fuzeren")=nowfuzeren
rs("jifen")=nowjifen
rs("beizhu")=nowbeizhu
rs("startdate")=nowstartdate
rs("enddate")=nowenddate
rs("shengri")=nowshengri
rs("yinyang")=nowyinyang
rs("qq")=nowqq
rs("email")=nowemail
rs("louyu")=nowlouyu <-------第280行
rs("xiaoqu")=nowxiaoqu
rs("shui")=nowshui
rs("dian")=nowdian
rs("wuye")=nowwuye
rs("qita")=nowqita
rs.update
%>
<script language="javascript">
alert("业主资料修改成功！")
window.location.href="yezhu.asp?form=<%=request("form")%>&field=<%=request("field")%>&field2=<%=request("field2")%>&field3=<%=request("field3")%>&page=<%=request("page")%>&louyu=<%=request("louyu")%>&keyword=<%=request("keyword")%>&order1=<%=request("order1")%>&order2=<%=request("order2")%>&order3=<%=request("order3")%>&order4=<%=request("order4")%>&order5=<%=request("order5")%>&order6=<%=request("order6")%>&order7=<%=request("order7")%>&order8=<%=request("order8")%>&order9=<%=request("order9")%>&order10=<%=request("order10")%>&order11=<%=request("order11")%>&order12=<%=request("order12")%>&order13=<%=request("order13")%>&order14=<%=request("order14")%>&order15=<%=request("order15")%>"
</script>  
<%end if%>
</body></html>================================代码结束

[ 本帖最后由 天蝎风 于 2010-11-17 12:06 编辑 ]
#3
天蝎风2010-11-17 12:06
我就搞不明白了，提交可以，修改类型又不匹配！
#4
dzt00012010-11-17 13:18
表单里没有名为louyu的控件，存储的时候nowlouyu是空值
#5
天蝎风2010-11-17 13:56
以下是引用dzt0001在2010-11-17 13:18:15的发言：

表单里没有名为louyu的控件，存储的时候nowlouyu是空值
恩，搞好了，感谢你的提示！
1
©2025, BC-CN.NET
电脑版