<%@ LANGUAGE="VBSCRIPT" %> <% DbPath = SERVER.MapPath("../database/topboy-2002.mdb") Set conn = Server.CreateObject("ADODB.Connection") conn.open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DbPath %> <% if request("browsdopage") <> "" then if isnumeric(request("browsdopage")) = false then response.write"" Response.write " 您好,页码请您填写数字!" Response.write "请按此返回..." Response.end end if end if result=Instr(1,request.ServerVariables("http_referer"),request.servervariables("http_host"),1) %> <% set rs=server.createobject("adodb.recordset") sql="select * from topboy_message where mtype like '%"&request("mtype")&"%' and title like '%"&request("bname")&"%' order by id DESC" B1=Request("B1") rs.open sql,conn,adOpenkeyset,adlockoptimistic,adcmdtext set rst=server.createobject("adodb.recordset") sqltext="select * from topboy_type" rst.open sqltext,conn,adOpenkeyset,adlockoptimistic,adcmdtext If request("imagedel.x") = "" Then if rs.eof and rs.bof then response.write"" Response.write "没有任何相关信息!" Response.write "*请按此返回..." Response.end end if set id=rs("id") set mtype=rs("mtype") set title=rs("title") set mdate=rs("mdate") RS.pagesize=50 RS.AbsolutePage = 1 dim page if request("browsdopage") <> "" then if cint(request("browsdopage")) > RS.pagecount then page = RS.pagecount else page = request("browsdopage") end if else page = request("page") end if if page = 0 then RS.AbsolutePage = 1 page = 1 else RS.AbsolutePage = page end if rowcount = RS.pagesize %> <% If Not RS.Eof Then %>
按信息标题模糊查找:
查询结果:本次查询共查询到 <% =RS.recordcount %> 条记录。第 <% if page = "" then response.write 1 else response.write page end if %> 页; 共 <% =RS.pagecount %> 页。
<% if page > 1 then %> <% else %> <% end if %> <% if page > 1 then %> <% else %> <% end if %> <% if cint(page) < rs.pagecount then %> <% else %> <% end if %> <% if cint(page) < rs.pagecount then %> <% else %> <% end if %>
<% Do While Not rs.EOF and i<50 i=i+1 %> <% rs.Movenext loop %>
类别
信息标题
发布日期
<% =mtype %>
&id=<%=rs("id")%>" target="_blank"> <% =title %>
<% =mdate %>
<% end if end if %>