<%@ Language=VBScript%> <% 'Option Explicit %> <% Response.Expires = 0 %> <% Response.Buffer = True %> <% cid = "jeongwoo" 'company id '### °øÁö»çÇ× sql = "select top 2 idx_id,title,regidate " sql = sql & "from T_board_notice " sql = sql & "where userid = '"& cid &"' " sql = sql & "and useflag = 'Y' " sql = sql & "order by regidate desc " Set DbConR1 = Server.CreateObject ("ADODB.RecordSet") DbConR1.Open sql,DBCon,1,1 '### ¾÷°è´º½º sql = "select top 2 idx_id,title,regdate " sql = sql & "from tblMoldBBS " sql = sql & "order by regdate desc " Set DbConR2 = Server.CreateObject ("ADODB.RecordSet") DbConR2.Open sql,DBCon,1,1 %> ¹ÏÀ» ¼ö ÀÖ´Â ±â¾÷-Á¤¿ìÁ¤¹Ð¿¡ ¿À½Å °ÍÀ» ȯ¿µÇÕ´Ï´Ù.

 

°ßÀû¿äûÆÇ°ú °Ô½ÃÆÇÀÌ

¸®´º¾óÁßÀÔ´Ï´Ù

<%if not(DbConR1.EOF and DbConR1.BOF) then do while not(DbConR1.EOF) title = DbConR1("title") if len(title) >= 18 then title = mid(title,1,15)&"..." end if%> <%DbConR1.MoveNext loop end if%>

¹®ÀÇ »çÇ×Àº ¸ÞÀÏ·Î º¸³»ÁÖ¼¼¿ä

¸ÞÀÏ::   jw674@chol.com
<%if not(DbConR2.EOF and DbConR2.BOF) then do while not(DbConR2.EOF) title = DbConR2("title") if len(title) >= 18 then title = mid(title,1,15)&"..." end if%> <%DbConR2.MoveNext loop end if%>
°¨»çÇÕ´Ï´Ù    


<%if admin_id = "" then%> <%else%> <%end if%>
<% DbConR1.close set DbConR1 = Nothing DbConR2.close set DbConR2 = Nothing %>