xujingchen 发表于 2005-10-29 03:19:51

[求助]高手帮忙

我的站内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 发表于 2005-10-29 09:42:37

re:晕了!看不懂!帮你顶!希望有人可以帮到你

晕了!看不懂!帮你顶!希望有人可以帮到你
页: [1]
查看完整版本: [求助]高手帮忙