% db.CursorLocation = 3 dim txtSearch, selSearch, Sqlwhere txtSearch = trim(Request("txtSearch")) selSearch = trim(Request("selSearch")) if len(txtSearch) > 0 then if selSearch = "C" then Sqlwhere = " where b_content like '%"& txtSearch &"%'" else Sqlwhere = " where b_subject like '%"& txtSearch &"%'" end if else Sqlwhere = "" end if Sql = "select * from board " sql = sql & sqlwhere sql = sql & " ORDER BY b_id DESC" set Rs = db.Execute(sql) dim GotoPage ,BlockPage,RecordCount, i RecordCount = RS.RecordCount GotoPage = request("GotoPage") if GotoPage= "" then GotoPage = 1 else GotoPage = GotoPage end if RS.PageSize=10 if RecordCount > 0 then RS.AbsolutePage=GotoPage end if BlockPage = int((GotoPage - 1) / 10) * 10 + 1 i = 0 %>
|
|||||||||||||||||||||||||||||||||||||||