|
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<br>
<br>
<br>
|
|