空调哪个品牌质量最好:ASP指定条件查询时出现的问题

测试页面时出现的问题为ADODB.Recordset (0x800A0BB9)
参数类型不正确，或不在可以接受的范围之内，或与其他参数冲突。
代码为:
set conn=server.CreateObject("adodb.connection")
conn.open("provider=microsoft.jet.oledb.4.0;data source="&server.MapPath("../msn.mdb"))

if sfieldif= "姓名" then
if modeif="等于" then
sql="select * from [message] where [姓名]='"&cvalueif&"'"
else
sql="select * from [message] where [姓名]like '%"&cvalueif&"%'"
end if
end if
if sfieldif="学号" then
if modeif="等于" then
sql="select * from [message] where [学号]='"&cvalueif&"'"
else
sql="select * from [message] where [学号] like '%"&cvalueif&"%'"
end if
end if
if sfieldif="寝室号码" then
if modeif="等于" then
sql="select * from [message] where [寝室号码]='"&cvalueif&"'"
else
sql="select * from [message] where [寝室号码] like '%"&cvalueif&"%'"
end if
end if

set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,1,3
%>