%@ Language=VBScript %>
<%Response.Buffer=TRUE%>
<%'On Error Resume Next %>
<%Base_TID = Session("Base_TID")%>
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Set Rs = Server.CreateObject("ADODB.RecordSet")
Conn.Open "DSN=Uboard;UID=brtech;PWD=berrsp;"
SQL = "select top 4 * from board_"&Base_TID&" where b_type='NOTICE' "
SQL =SQL +"order by ref desc, pos, depth "
Rs.Open SQL, Conn, 3
Set Rs_Qna = Server.CreateObject("ADODB.RecordSet")
SQL_Qna = "select top 4 * from board_"&Base_TID&" where b_type='QNA' "
SQL_Qna =SQL_Qna +"order by ref desc, pos, depth "
Rs_Qna.Open SQL_Qna, Conn, 3
%>
***½ÅÈ«Áø±â¾÷(ÁÖ)¿¡ ¿À½Å°ÍÀ» ȯ¿µÇÕ´Ï´Ù***
»ó´Ü¿µ¿ª
<% row1 = 0
if Not Rs.BOF AND Not Rs.EOF then
DO WHILE NOT Rs.EOF
Title = Mid(Rs("subject"),1,50)
regdate = Rs("regdate")
num = Rs("num")
row1= row1 + 1
%>
<%=Title%>
<%=mid(regdate,1,10)%>
<%Rs.MoveNext
Loop
End if
' Response.Write row1
For i = row1 To 3 STEP 1
%>
<% NEXT
%>
<% row2 = 0
if Not Rs_Qna.BOF AND Not Rs_Qna.EOF then
DO WHILE NOT Rs_Qna.EOF
Title = Mid(Rs_Qna("subject"),1,50)
regdate = Rs_Qna("regdate")
depth= Rs_Qna("depth")
num2= Rs_Qna("num")
row2= row2+1
%>
<%i = 1
Do While i <= depth
Response.Write "¡¡"
i= i+1
Loop
Response.Write Title
%>
<%=mid(regdate,1,10)%>
<% Rs_Qna.MoveNext
Loop
End if
For i = row1 To 3 STEP 1
%>