% 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 %>
| °Ô½ÃÇÒ ³»¿ëÀÌ ¾ø½À´Ï´Ù |
<% Else %>
| Á¦ ¸ñ | 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 " |
<% if UCase(left(Rs("ftp"),4))="HTTP" or UCase(left(Rs("ftp"),4))="FTP:" then %>
" 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") %> | <% end if '''------------------------------------------------------------------------------------- '' ''' step ÀÌ 0ÀÌ ¾Æ´Ï¸é Áï,, ´äº¯À̸é.. '''---------------------------------------------------------------------- k = k + 1 rs.MoveNext LOOP %>