Question

Provider (0x80020005)如何解决？

错误类型：
Provider (0x80020005)
类型不匹配。
/pjlgsj_admin/save_product.asp, 第 19 行

浏览器类型：
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; GTB6)

网页：
POST 174 ??? /pjlgsj_admin/save_product.asp

POST Data:
product_name=%C3%C5%BB%A8&enproduct_name=wzm0011&product_sort=CZ-8001&gg=wzm0011&jg=85&sort_id=68&title_pic=&pass=1&sx=&product_info=sf&enproduct_info=&Submit=+%CC%E1+%BD%BB+

下面我贴出ASP代码，product_save.asp

<!--#include file="cookies.asp"-->
<!--#include file="conn.asp"-->
<% if request.querystring("action")="add" then
if trim(request.form("product_name"))="" then
response.Write "<script language=javascript>alert('产品名称不能为空！');window.location.href='add_product.asp';</script>"
response.end
end if
set rs=server.createobject("adodb.recordset")
sql="select * from product_info "
rs.open sql,conn,1,3
rs.addnew
rs("sort_id")=trim(request.form("sort_id"))
rs("product_name")=trim(request.form("product_name"))
rs("enproduct_name")=trim(request.form("enproduct_name"))
rs("product_sort")=trim(request.form("product_sort"))
rs("gg")=trim(request.form("gg"))
rs("small_img")=trim(request.form("title_pic"))
rs("jg")=trim(request.form("jg"))
rs("tuijian")=trim(request.form("tuijian"))
rs("pass")=trim(request.form("pass"))
rs("sx")=trim(request.form("sx"))
rs("product_info")=trim(request.form("product_info"))
rs("enproduct_info")=trim(request.form("enproduct_info"))
rs.update
'response.Write "<script language=javascript>alert('添加产品成功！');window.location.href='add_product.asp';/script>"
rs.close
set rs=nothing

response.Write "<script language=javascript>alert('添加产品成功！');window.location.href='add_product.asp';</script>"
conn.close
set conn=nothing
end if
%>
<% if request.querystring("action")="edit" then
if trim(request.form("product_name"))="" then
response.Write "<script language=javascript>alert('产品名称不能为空！');window.location.href='add_product.asp';</script>"
response.end
end if
set rs=server.createobject("adodb.recordset")
sql="select * from product_info where id="&request.form("id")&" "
rs.open sql,conn,1,3
rs("sort_id")=trim(request.form("sort_id"))
rs("product_name")=trim(request.form("product_name"))
rs("enproduct_name")=trim(request.form("enproduct_name"))
rs("product_sort")=trim(request.form("product_sort"))
rs("gg")=trim(request.form("gg"))
rs("jg")=trim(request.form("jg"))
rs("small_img")=trim(request.form("title_pic"))
if trim(request.form("tuijian"))<>"" then
rs("tuijian")=trim(request.form("tuijian"))
else
rs("tuijian")=0
end if
if trim(request.form("pass"))<>"" then
rs("pass")=trim(request.form("pass"))
else
rs("pass")=0
end if
if trim(request.form("sx"))<>"" then rs("sx")=trim(request.form("sx"))
rs("product_info")=trim(request.form("product_info"))
rs("enproduct_info")=trim(request.form("enproduct_info"))
rs.update
rs.close
set rs=nothing

下面发不下了，请高手指点一下，谢谢！
每十九行是rs("tuijian")=trim(request.form("tuijian"))

Answer 1

rs("jg")=trim(request.form("jg"))
rs("tuijian")=trim(request.form("tuijian"))

检查这两个字段(没数清楚哪个是19行),提交的值与数据库中的类型不一致.