请论坛高手帮看看这段代码
Microsoft VBScript 运行时错误 '800a000d'
类型不匹配: 'rs'
\manage\Photo\Photo_Edit.asp, line 68
下面是代码
<!-- #include file="../Include/Chk.asp" -->
<!-- #include file="../Include/Conn.asp" -->
<!-- #include file="../Include/Jpeg.asp" -->
<%
function cs(str)
str=Replace(str,chr(13),"<br>")
str=Replace(str," "," ")
str=Replace(str," "," ")
cs=str
end function
if Request.QueryString("Action")="add" then
img=Trim(Request.Form("img"))
if img="" then
Response.Write ("<script>alert('请上传图片！');history.back();</script>")
Response.End()
else
set rs=Server.CreateObject("Adodb.recordset")
sql="select * from photo"
rs.open sql,conn,1,3
rs.Addnew
rs("name")=Request.Form("name")
rs("url")=img
rs("info")=cs(Request.Form("info"))
rs("user")=Trim(Request.Form("user"))
rs("school")=Trim(Request.Form("school"))
rs("tea")=Trim(Request.Form("tea"))
rs("qq")=Trim(Request.Form("qq"))
rs("mail")=Trim(Request.Form("mail"))
rs.Update
rs.Close
'====生成缩略图
'call aspjpeg("../Upload/UploadImages/"&img,"../Upload/UploadImages_s/"&img,120,135)
'====生成缩略图
Response.Write ("<script>alert('添加成功！');location.href='Photo_Add.asp';</script>")
end if
end if
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.
<html xmlns="http://www.
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title></title>
<link href="images/admin_STYLE.css" rel="stylesheet" type="text/css" />
<link href="../Images/default.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form id="form1" name="form1" method="post" onSubmit="return Validator.Validate(this,3)" action="?Action=edit&id=<%=id%>">
<table width="100%%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="30" colspan="3" align="left" valign="middle" bgcolor="#efefef" class="title">修改产品</td>
</tr>
<tr>
<td width="100" align="center" valign="middle" bgcolor="#EFEFEF">*产品名称：</td>
<td height="30" colspan="2" align="left" valign="middle" bgcolor="#efefef"><input name="name" type="text" id="name" value="<%=rs("name")%>" size="20" maxlength="20" datatype="Require" msg="不能为空" /></td>
</tr>
<tr>
<td width="100" align="center" valign="middle" bgcolor="#EFEFEF">产品编号：</td>
<td height="30" colspan="2" align="left" valign="middle" bgcolor="#efefef"><input name="user" type="text" id="user" value="<%=rs("user")%>" size="20" maxlength="20" datatype="Require" msg="不能为空" /></td>
</tr>
<tr>
<td width="100" align="center" valign="middle" bgcolor="#EFEFEF">*市场价格：</td>
<td height="30" colspan="2" align="left" valign="middle" bgcolor="#efefef"><input name="school" type="text" id="school" value="<%=rs("school")%>" size="20" maxlength="20" datatype="Require" msg="不能为空" /></td>
</tr>
<tr>
<td width="100" align="center" valign="middle" bgcolor="#EFEFEF">*生产日期：</td>
<td height="30" colspan="2" align="left" valign="middle" bgcolor="#efefef"><input name="tea" type="text" id="tea" value="<%=rs("tea")%>" size="20" maxlength="20" datatype="Require" msg="不能为空" /></td>
</tr>
<tr>
<td width="100" align="center" valign="middle" bgcolor="#EFEFEF">防 伪 码：</td>
<td height="30" colspan="2" align="left" valign="middle" bgcolor="#EFEFEF"><input name="qq" id="qq" value="<%=rs("qq")%>" size="50" maxlength="50" datatype="Require" msg="不能为空" /></td>
</tr>
<tr>
<td width="100" height="25" align="center" valign="middle" bgcolor="#efefef">查询次数：</td>
<td height="25" colspan="2" align="left" valign="middle" bgcolor="#efefef"> </td>
</tr>
<tr align="left" valign="middle">
<td width="100" height="150" align="center" bgcolor="#efefef">产品简介：</td>
<td bgcolor="#efefef"><textarea name="info" cols="55" rows="10" id="info" ><%=cs2(rs("info"))%></textarea></td>
<td bgcolor="#efefef"> </td>
</tr>
<tr align="left" valign="middle">
<td width="100" height="150" align="center" bgcolor="#efefef">产品图片：</td>
<td width="350" bgcolor="#efefef">
<iframe src='../Upload/view.asp?path=<%=rs("url")%>' name='i2' width="350" height="150" scrolling="No" frameborder="0" id="i2"></iframe> </td>
<td width="312" bgcolor="#efefef"><input name="img" type="hidden" id="img" value="<%=rs("url")%>" datatype="Require" msg="请上传图片" /></td>
</tr>
<tr>
<td width="100" height="25" align="right" valign="middle" bgcolor="#efefef"> </td>
<td height="25" colspan="2" align="left" valign="middle" bgcolor="#efefef"><input type="submit" name="Submit" value=" 修 改 " /></td>
</tr>
</table>
</form>
<script>
Validator = {
Require : /.+/,
Email : /^\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*$/,
Phone : /^((\(\d{2,3}\))|(\d{3}\-))?(\(0\d{2,3}\)|0\d{2,3}-)?[1-9]\d{6,7}(\-\d{1,4})?$/,
Mobile : /^((\(\d{2,3}\))|(\d{3}\-))?13\d{9}$/,
Url : /^http:\/\/[A-Za-z0-9]+\.[A-Za-z0-9]+[\/=\?%\-&_~`@[\]\':+!]*([^<>\"\"])*$/,
IdCard : "this.IsIdCard(value)",
Currency : /^\d+(\.\d+)?$/,
Number : /^\d+$/,
Zip : /^[1-9]\d{5}$/,
QQ : /^[1-9]\d{4,8}$/,
Integer : /^[-\+]?\d+$/,
Double : /^[-\+]?\d+(\.\d+)?$/,
English : /^[A-Za-z]+$/,
Chinese : /^[\u0391-\uFFE5]+$/,
Username : /^[a-z]\w{3,}$/i,
UnSafe : /^(([A-Z]*|[a-z]*|\d*|[-_\~!@#\$%\^&\*\.\(\)\[\]\{\}<>\?\\\/\'\"]*)|.{0,5})$|\s/,
IsSafe : function(str){return !this.UnSafe.test(str);},
SafeString : "this.IsSafe(value)",
Filter : "this.DoFilter(value, getAttribute('accept'))",
Limit : "this.limit(value.length,getAttribute('min'), getAttribute('max'))",
LimitB : "this.limit(this.LenB(value), getAttribute('min'), getAttribute('max'))",
Date : "this.IsDate(value, getAttribute('min'), getAttribute('format'))",
Repeat : "value == document.getElementsByName(getAttribute('to'))[0].value",
Range : "getAttribute('min') < (value|0) && (value|0) < getAttribute('max')",
Compare : "(value,getAttribute('operator'),getAttribute('to'))",
Custom : "this.Exec(value, getAttribute('regexp'))",
Group : "this.MustChecked(getAttribute('name'), getAttribute('min'), getAttribute('max'))",
ErrorItem : [document.forms[0]],
ErrorMessage : ["以下原因导致提交失败：\t\t\t\t"],
Validate : function(theForm, mode){
var obj = theForm || event.srcElement;
var count = obj.elements.length;
this.ErrorMessage.length = 1;
this.ErrorItem.length = 1;
this.ErrorItem[0] = obj;
for(var i=0;i<count;i++){
with(obj.elements[i]){
var _dataType = getAttribute("dataType");
if(typeof(_dataType) == "object" || typeof(this[_dataType]) == "undefined") continue;
this.ClearState(obj.elements[i]);
if(getAttribute("require") == "false" && value == "") continue;
switch(_dataType){
case "IdCard" :
case "Date" :
case "Repeat" :
case "Range" :
case "Compare" :
case "Custom" :
case "Group" :
case "Limit" :
case "LimitB" :
case "SafeString" :
case "Filter" :
if(!eval(this[_dataType])) {
this.AddError(i, getAttribute("msg"));
}
break;
default :
if(!this[_dataType].test(value)){
this.AddError(i, getAttribute("msg"));
}
break;
}
}
}
if(this.ErrorMessage.length > 1){
mode = mode || 1;
var errCount = this.ErrorItem.length;
switch(mode){
case 2 :
for(var i=1;i<errCount;i++)
this.ErrorItem[i].style.color = "red";
case 1 :
alert(this.ErrorMessage.join("\n"));
this.ErrorItem[1].focus();
break;
case 3 :
for(var i=1;i<errCount;i++){
try{
var span = document.createElement("SPAN");
span.id = "__ErrorMessagePanel";
span.style.color = "red";
this.ErrorItem[i].parentNode.appendChild(span);
span.innerHTML = this.ErrorMessage[i].replace(/\d+:/,"*");
}
catch(e){alert(e.description);}
}
this.ErrorItem[1].focus();
break;
default :
alert(this.ErrorMessage.join("\n"));
break;
}
return false;
}
return true;
},
limit : function(len,min, max){
min = min || 0;
max = max || Number.MAX_VALUE;
return min <= len && len <= max;
},
LenB : function(str){
return str.replace(/[^\x00-\xff]/g,"**").length;
},
ClearState : function(elem){
with(elem){
if(style.color == "red")
style.color = "";
var lastNode = parentNode.childNodes[parentNode.childNodes.length-1];
if(lastNode.id == "__ErrorMessagePanel")
parentNode.removeChild(lastNode);
}
},
AddError : function(index, str){
this.ErrorItem[this.ErrorItem.length] = this.ErrorItem[0].elements[index];
this.ErrorMessage[this.ErrorMessage.length] = this.ErrorMessage.length + ":" + str;
},
Exec : function(op, reg){
return new RegExp(reg,"g").test(op);
},
compare : function(op1,operator,op2){
switch (operator) {
case "NotEqual":
return (op1 != op2);
case "GreaterThan":
return (op1 > op2);
case "GreaterThanEqual":
return (op1 >= op2);
case "LessThan":
return (op1 < op2);
case "LessThanEqual":
return (op1 <= op2);
default:
return (op1 == op2);
}
},
MustChecked : function(name, min, max){
var groups = document.getElementsByName(name);
var hasChecked = 0;
min = min || 1;
max = max || groups.length;
for(var i=groups.length-1;i>=0;i--)
if(groups[i].checked) hasChecked++;
return min <= hasChecked && hasChecked <= max;
},
DoFilter : function(input, filter){
return new RegExp("^.+\.(?=EXT)(EXT)$".replace(/EXT/g, filter.split(/\s*,\s*/).join("|")), "gi").test(input);
},
IsIdCard : function(number){
var date, Ai;
var verify = "10x98765432";
var Wi = [7, 9, 10, 5, 8, 4, 2, 1, 6, 3, 7, 9, 10, 5, 8, 4, 2];
var area = ['','','','','','','','','','','','北京','天津','河北','山西','内蒙古','','','','','','辽宁','吉林','黑龙江','','','','','','','','上海','江苏','浙江','安微','福建','江西','山东','','','','河南','湖北','湖南','广东','广西','海南','','','','重庆','四川','贵州','云南','西藏','','','','','','','陕西','甘肃','青海','宁夏','新疆','','','','','','台湾','','','','','','','','','','香港','澳门','','','','','','','','','国外'];
var re = number.match(/^(\d{2})\d{4}(((\d{2})(\d{2})(\d{2})(\d{3}))|((\d{4})(\d{2})(\d{2})(\d{3}[x\d])))$/i);
if(re == null) return false;
if(re[1] >= area.length || area[re[1]] == "") return false;
if(re[2].length == 12){
Ai = number.substr(0, 17);
date = [re[9], re[10], re[11]].join("-");
}
else{
Ai = number.substr(0, 6) + "19" + number.substr(6);
date = ["19" + re[4], re[5], re[6]].join("-");
}
if(!this.IsDate(date, "ymd")) return false;
var sum = 0;
for(var i = 0;i<=16;i++){
sum += Ai.charAt(i) * Wi[i];
}
Ai += verify.charAt(sum%11);
return (number.length ==15 || number.length == 18 && number == Ai);
},
IsDate : function(op, formatString){
formatString = formatString || "ymd";
var m, year, month, day;
switch(formatString){
case "ymd" :
m = op.match(new RegExp("^((\\d{4})|(\\d{2}))([-./])(\\d{1,2})\\4(\\d{1,2})$"));
if(m == null ) return false;
day = m[6];
month = m[5]*1;
year = (m[2].length == 4) ? m[2] : GetFullYear(parseInt(m[3], 10));
break;
case "dmy" :
m = op.match(new RegExp("^(\\d{1,2})([-./])(\\d{1,2})\\2((\\d{4})|(\\d{2}))$"));
if(m == null ) return false;
day = m[1];
month = m[3]*1;
year = (m[5].length == 4) ? m[5] : GetFullYear(parseInt(m[6], 10));
break;
default :
break;
}
if(!parseInt(month)) return false;
month = month==0 ?12:month;
var date = new Date(year, month-1, day);
return (typeof(date) == "object" && year == date.getFullYear() && month == (date.getMonth()+1) && day == date.getDate());
function GetFullYear(y){return ((y<30 ? "20" : "19") + y)|0;}
}
}
</script>
</body>
</html>
