这样的错误是什么原因?
adf
ADODB.Recordset 错误 '800a0bb9'
参数类型不正确，或不在可以接受的范围之内，或与其他参数冲突。
/www/member_add.asp，行 14
以下是原代码:
if request("action")="add" then
serial_num=request("serial_num")
response.write serial_num
sql="select * from member where serial_num='"&serial_num&"'"
set rs=server.createobject("ADODB.recordset")
rs.open sql,conn,1,3
if rs.eof and rs.bof then
rs.addnew
rs("serial_num")=trim(request("serial_num"))
rs("company_name")=trim(request("company_num"))
rs("corp_name")=trim(request("corp_name"))
rs("corp_phone")=trim(request("corp_phone"))
rs("corp_mobile")=trim(request("corp_mobile"))
rs("corp_email")=trim(request("corp_email"))
rs("corp_fax")=trim(request("corp_fax"))
rs("corp_address")=trim(request("corp_address"))
rs("cont_name")=trim(request("cont_name"))
rs("cont_phone")=trim(request("cont_phone"))
rs("cont_mobile")=trim(request("cont_mobile"))
rs("cont_email")=trim(request("cont_email"))
rs("cont_fax")=trim(request("cont_fax"))
rs("cont_address")=trim(request("cont_address"))
rs.update
rs.close
set rs=nothing
else
response.write "<script language='javascript'>alert('此会员编号已经存在,请重新添加!');</script>"
end if
