% mTop=5 %> <% Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open strConnect mSearchFlag = Request.QueryString("search") if mSearchFlag = 1 then mSearchType = Request.Form("SearchType") mSearchWord = Request.Form("SearchWord") mSearchType = "4" if mSearchType = "" then %> <% Response.end else if mSearchType = "1" or mSearchType = "2" or mSearchType = "3" or mSearchType = "4" then if mSearchWord = "" then %> <% Response.end end if end if mSql = "select * from tbl_kcsBoard where " mSql = mSql & " fText like '%" & mSearchWord & "%' or fTitle like '%" & mSearchWord & "%' " mSql = mSql & " order by fParent desc, fReplyNo " end if else mSql = "select * from tbl_kcsBoard order by fParent desc, fReplyNo " end if Set oRs = Server.CreateObject("ADODB.RecordSet") oRs.PageSize = mMaxNum oRs.Open mSql,objConn,1 if Not oRs.EOF then mRecordCount = oRs.RecordCount mPageCount = oRs.PageCount mAbsPage = Request.QueryString("pg") if mAbsPage = "" then oRs.AbsolutePage = 1 mAbsPage = 1 else oRs.AbsolutePage = mAbsPage end if mRealPage = cint(mPageCount)-cint(mAbsPage) +1 end if %>
|