[求助]高手帮忙

xujingchen

我的站内asp搜索引擎用access发现数据库里的有些数据在查询时查不到，下面是代码，请高手帮忙。<br>
Set rs= Server.CreateObject("ADODB.Recordset")<br>
if stype="Singer" then<br>
sql="select * from Nclass where Nclass Like '%"& keyword &"%' order by Nclassid desc"<br>
elseif stype="Music" then <br>
sql="select * from MusicList where MusicName Like '%"& keyword &"%' "<br>
<br>
elseif stype="Special" then<br>
sql="select * from Special where Name Like '%"& keyword &"%' order by Specialid desc"<br>
else<br>
end if<br>
'response.write sql<br>
'response.end<br>
rs.open sql,conn,1,1<br>
<br>
if not isempty(request.QueryString("page")) then<br>
currentPage=cint(request.QueryString("page"))<br>
else<br>
currentPage=1<br>
end if<br>
if rs.eof and rs.bof

jaffas1101

晕了！看不懂！帮你顶！希望有人可以帮到你