Microsoft VBScript 运行时错误 (0x800A000D)类型不匹配: 'rsup'
来源:百度知道 编辑:UC知道 时间:2024/06/02 23:54:11
<% id=trim(request("id"))
set rsup=server.createobject("adodb.recordset")
rsup.open "select * from web where id="&id,conn,3,3
%>
<%if request("action")="up" then
flag=1
upnum=FormatNumber(request("upnum"),0)
sqlup="update web set num="&upnum&" where id ="&id
conn.execute sqlup
end if
if flag=1 then
%>
<script language="javascript">
alert("修改成功!");
window.navigate("search.asp")
</script>
<% rsup.close
set rsup=nothing
end if%>
<form name="formup" method="post" action="?action=up" onSubmit="return checkup()">
<input name=id type="hidden" value=<%=request("id")%>>
<table width="40%" border="1" align=
set rsup=server.createobject("adodb.recordset")
rsup.open "select * from web where id="&id,conn,3,3
%>
<%if request("action")="up" then
flag=1
upnum=FormatNumber(request("upnum"),0)
sqlup="update web set num="&upnum&" where id ="&id
conn.execute sqlup
end if
if flag=1 then
%>
<script language="javascript">
alert("修改成功!");
window.navigate("search.asp")
</script>
<% rsup.close
set rsup=nothing
end if%>
<form name="formup" method="post" action="?action=up" onSubmit="return checkup()">
<input name=id type="hidden" value=<%=request("id")%>>
<table width="40%" border="1" align=
<td width="70%"><input name="upnum" type="text" value=<%=rsup("npnum")%> ></td>
你这个输入值的类型和数据库表里字段的定义不一样
type="text" ,不数据库端的数据类型是不是 文本 类型的,如果不是就是这个错误,