懂ASP的大侠请进来帮帮忙!感激不尽!

来源:百度知道 编辑:UC知道 时间:2024/06/13 02:25:55
这个代码是什么意思?

<%
Set rsSearchResults = Nothing
Set rsSearchResults = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT top 5 * FROM MB_Info where tj=1 ORDER By SiteIDNo DESC "
rsSearchResults.Open strSQL, strCon, 3
if rsSearchResults.eof and rsSearchResults.bof then
response.write "<p align='center'>暂无推荐信息 </p>"
else
filename=1
%>

我搞的推荐信息,怎么总是不会动
我估计问题就是出在这里了

帮帮忙………………

拜托!!!

rsSearchResults.Open strSQL, strCon,1,3

开头就将对象销毁了当然不行. 将=nothing一句放到最后

rsSearchResults.Open strSQL, strCon, 1,3

end if 也没有了啊!

<%
Set rsSearchResults = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT top 5 * FROM MB_Info where tj=1 ORDER By SiteIDNo DESC "
rsSearchResults.Open strSQL, strCon, 3
if rsSearchResults.eof and rsSearchResults.bof then
response.write "<p align='center'>暂无推荐信息 </p>"
else
filename=1
end if
rsSearchResults.close
Set rsSearchResults = Nothing
%>