北京赛德美:怎样修改我的错误啊?SQL+ASP QQ52130314

来源:百度文库 编辑:查人人中国名人网 时间:2024/05/12 17:24:39
会员等级: SELECT F_Value FROM citycard_grade Where F_ID=普通商家
Microsoft VBScript 运行时错误 错误 '800a01a8'

缺少对象: '[undefined]'

/biz/Search.asp,行 131

就是:
“Set rst = conn.Execute(m_SQL)
” 有问题

具体错误代码如下

<td width="47%" > <% if rs("iscard")="1,0" then %> <img src="../Member/Images/nbcard.gif" alt="都市卡加盟商">
<% end if %> <strong>会员等级:<font color="#FF3300">
<%
m_SQL = "SELECT F_Value FROM citycard_grade Where F_ID=" & rs("grade")
Set rst = conn.Execute(m_SQL)
if not rst.Eof then
%>
<%=rst(0)%>
<% end if
rst.close
set rst=nothing
%>
</font></strong></td>

m_SQL = "SELECT F_Value FROM citycard_grade Where F_ID='" & rs("grade") & "'"