<%set rs=server.createobject("adodb.recordset")                     
sql="select * from SMT_price order by SMT_id desc"
rs.open sql,conn,1,1     
set rs1=server.CreateObject("adodb.recordset")
sql="select * from SMT_member where SMT_company_id="& ypid
rs1.open sql,conn,1,1
%>
<td><%if rs1("SMT_comphone")="" then
response.write rs("SMT_phone")
else
response.write rs1("SMT_comphone")
end if%></td>
提示是错误类型:(0x80020009)发生意外
哪里出现问题了？

sql="select * from SMT_member where SMT_company_id="& ypid
rs1.open sql,conn,1,1
改成
sql1="select * from SMT_member where SMT_company_id="& ypid
rs1.open sql1,conn,1,1

<td><%if rs1("SMT_comphone")="" then
response.write rs("SMT_phone")
else
response.write rs1("SMT_comphone")
end if%></td>
改成
<td><%if isnull(rs1("SMT_comphone")) then
response.write rs("SMT_phone")
else
response.write rs1("SMT_comphone")
end if%></td>

支持楼上的