<% response.expires = 0 response.buffer = true cPage=Request("cPage") searchKey=trim(request("searchKey")) SearchText=trim(Request("searchText")) If IsEmpty(cPage) Then cPage=1 End if cPage=cPage+0 set conn = Server.CreateObject("Adodb.Connection") ' pathe = "DBQ=" & server.MapPath("board.mdb") & ";DefaultDir="& server.mappath("board.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};FIL=MS Access;ImplicitCommitSync=Yes;MaxBufferSize=1024;MaxScanRows=16;PageTimeout=20;SafeTransactions=0;Threads=16;UID=;UserCommitSync=Yes;" ' Conn.Open "Dsn=Cboard;uid=;pwd=" conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;data source=" & server.MapPath("board.mdb") ' conn.Open pathe %> <% set com = Server.CreateObject("Adodb.command") com.activeconnection = conn if searchKey="" and SearchText="" Then com.commandtext = "SELECT number,subject,ftp,writer,date,visited,email,fnum,sortid,respid,list FROM boardtable ORDER BY list DESC" Elseif searchKey="date" then syear = split(searchtext,"-") com.commandtext = "SELECT number,subject,ftp,writer,date,visited,email,fnum,sortid,respid,list FROM boardtable Where year(date) = "& syear(0) &" and month(date) = "& syear(1) &" and day(date) = " & syear(2) &" ORDER BY list desc" elseif searchKey="total" then com.commandtext = "SELECT number,subject,ftp,writer,date,visited,email,fnum,sortid,respid,list FROM boardtable Where subject LIKE '%%%"&SearchText&"%%%' OR content LIKE '%%%"&SearchText&"%%%' ORDER BY list desc" else com.commandtext = "SELECT number,subject,ftp,writer,date,visited,email,fnum,sortid,respid,list FROM boardtable Where "&SearchKey&" LIKE '%%%"&SearchText&"%%%' ORDER BY list DESC" End If Set Rs=Server.CreateObject("ADODB.Recordset") rs.pagesize=page_cnt Rs.CursorType=1 rs.cachesize = page_cnt rs.open com If cPage > Rs.PageCount Then cPage = Rs.PageCount End If If cPage < 1 Then cPage = 1 End If %> <%= title & " - ½´ÆÛ ÇØÀûº¸µå(www.haejuk.com) "%>

°Ô½ÃÆÇ ÀÔ´Ï´Ù.


ȨÀ¸·Î <% If cPage > 1 Then %> óÀ½À¸·Î <% Else %> óÀ½À¸·Î <% End If %> <% If cPage > 1 Then %> ¾ÕÆäÀÌÁö <% Else %> ¾ÕÆäÀÌÁö <% End If %>   <%= cPage %> / <%= rs.PageCount %>   <% If cPage < rs.PageCount Then %> ´ÙÀ½ÆäÀÌÁö <% Else %> ´ÙÀ½ÆäÀÌÁö <% End If %> <% If cPage < rs.PageCount Then %> ¸¶Áö¸·À¸·Î <% Else %> ¸¶Áö¸·À¸·Î <% End If %> ±Û¿Ã¸®±â

<% if Rs.bof = true Then %>
°Ô½ÃÇÒ ³»¿ëÀÌ ¾ø½À´Ï´Ù



<% Else %> <% rs.AbsolutePage = cpage k = 1 DO WHILE NOT rs.EOF and k <= rs.pagesize %> <% if UCase(left(Rs("ftp"),4))="HTTP" or UCase(left(Rs("ftp"),4))="FTP:" then %> <% else %> <% end if '''------------------------------------------------------------------------------------- '' ''' step ÀÌ 0ÀÌ ¾Æ´Ï¸é Áï,, ´äº¯À̸é.. '''---------------------------------------------------------------------- k = k + 1 rs.MoveNext LOOP %>
Á¦ ¸ñ U R L ±Û ¾´ ÀÌ ³¯ Â¥ Á¶È¸¼ö
<% if rs("fnum") <> 0 then if searchkey = "" then for i = 1 to rs("fnum") response.write " " next end if if cint(rs("date") - now()) < 2 then response.write " " else Response.Write " " end if else if cint(rs("date") - now()) < 2 then response.write " " else Response.Write " " end if end if %> &cpage=<%=cPage %>&fnum=<%=rs("fnum")%>&searchkey=<%=searchkey %>&searchtext=<%=searchtext%>')"> <% if rs("fnum") <> 0 then %> <%= rs("subject") %> <% else %> <%= rs("subject") %> <% end if %> " target="_blank" title="<%= rs("ftp") %>"> <% if Ucase(left(Rs("ftp"),4))="HTTP" then %> HTTP <% else %> FTP <% end if %> " title=<%= rs("email") %>><%= rs("writer") %> <%= formatdatetime(rs("date"),2) %> <%= rs("visited") %>
No Link <%= rs("writer") %> <%= left(rs("date"),10) %> <%= rs("visited") %>

[ ÆäÀÌÁö: <% intNumOfPage=15 intstart = ((cpage-1) \ intNumOfPage) * intNumOfPage + 1 intEnd = (((cpage-1) + intNumOfPage) \ intNumOfPage) * intNumOfPage if Rs.Pagecount <= intEnd then intEnd = Rs.Pagecount end if if cpage > intNumOfPage then %> ÀÌÀü<%=intNumOfPage%>°³ <% End If For a = intStart To intEnd If a = cpage Then Response.Write a else %> <%=a%> <% End If Next if Rs.Pagecount > intEnd then %> <% end if %> ] <% end if %>


ã¾Æ º¸±â:
³¯Â¥ °Ë»ö½Ã 2000-01-01 ÇüÅ·ΠÀÔ·ÂÇϼ¼¿ä. Admin

Copyright ⓒ 1997 - 2000 Haejuk, Inc. and Haejuk Korea, Inc. All Rights Reserved.
<% rs.close set rs = nothing conn.close set conn = nothing %>