<% '------------------------------------------------------------------------------- 'Template '------------------------------------------------------------------------------- %> <% '------------------------------------------------------------------------------- 'Config '------------------------------------------------------------------------------- Public Sub Config() Page.S = fn.dic("s") Page.Cate = "1030000" End Sub '------------------------------------------------------------------------------- 'Local Function '------------------------------------------------------------------------------- '------------------------------------------------------------------------------- 'Content '------------------------------------------------------------------------------- Public Sub RenderContent() %> <% dim seq,fg,lastQidx,isWrite seq = fn.dic("seq") fg = 0 lastQidx = 0 isWrite = 0 set db = new dbclass db.sql = "SELECT fg FROM popup_info WHERE popno=2;" 'db.view set rs = db.execrs() : db.clear() if not rs.eof then fg = rs(0) ' fg:1À̸é how to say ±Û¾²±â ¹öư showó¸® rs.close : set rs = nothing ' ±Û¾²±â¿©ºÎ °¡Á®¿À±â db.sql = "SELECT isWrite FROM popup_info WHERE popNo=2" set rs = db.execrs() : db.clear() if not rs.eof then isWrite = rs(0) rs.close : set rs = nothing if fg=1 then db.sql = "SELECT top 1 qidx FROM Board where QUnique ='40000000' and QDelFg = 0 order by Qidx desc" set rs = db.execrs() : db.clear() if not rs.eof then lastQidx = rs(0) ' ÇöÀç ÁøÇàÁßÀÎ how to say ¹øÈ£ °¡Á®¿À±â rs.close : set rs = nothing end if db.sql = "SELECT * FROM Board WHERE QUnique=40000000 and QIdx=" & seq & " ;" db.sql = "UPDATE Board SET QRead=QRead+1 WHERE QUnique=40000000 and QIdx=" & seq & " ;" 'db.view set rs = db.execrs() set db = nothing %>
Á¦¸ñ <%=rs("QTitle")%>
ÀÛ¼ºÀÚ °ü¸®ÀÚ ÀÛ¼ºÀÏ <%=left(rs("QDate"),10)%>

<%=replace(rs("QContent"),"http://file.themavens.co.kr","")%>
<% if rs("qidx")=lastQidx and isWrite=1 then response.write "" end if%> ">
<% set db = new dbclass db.sql = "SELECT * FROM BoardComment WHERE qunique=" & seq & " AND CDelFg=0 AND cdetc2=0 order by cdate desc;" 'db.view set rs = db.execrs() set db = nothing ' Set Listing = new ListClass ' Listing.SetLow = 11 ' Listing.Columm = " * " ' Listing.Short = " cidx DESC " ' Listing.Table = " BoardComment " ' Listing.CountSql = "select count(*) from BoardComment where QUnique=" & seq & " AND CDelFg=0 and cdetc2=0 ;" ' Listing.Condition = " QUnique=" & seq & " AND CDelFg=0 and cdetc2=0 " 'Listing.Dbview = true ' Set rs = Listing.execrs() %> <%if not (rs.eof or rs.bof) then%>
How to say
<%do until rs.eof%> <%rs.movenext:loop%>
¡æ <%=rs("MID")%>  <%=Replace(rs("CContent"), chr(13), "
")%>
<%=left(rs("CDate"),10)%>
<%'=Listing.Paging2("")%>
<%end if%>
<% End Sub %>