<% '==================================================================== ' Wine Research '==================================================================== %> <% Call NoCaching() Call DBOpen() Dim strTable : strTable = "wine_research_wine" Dim intNo_RS : intNo_RS = Request("intNo_RS") If intNo_RS = "" Then intNo_RS = GetResearchNo() Dim intYear, intMonth, strTitle, strWriter, strImg_title, strImg_Content1, strIntro Dim blnResult Dim strPath blnResult = GetResearchInfo2(intNo_RS, intYear, intMonth, strTitle, strWriter, strImg_title, strImg_Content1, strIntro) If Not blnResult Then JsMsg "","location.href='/';",True Else strWriter = ChgTextMode(strWriter,False) ' strIntro = ChgTextMode(strIntro, True) strIntro = Replace(strIntro, chr(13)&chr(10), "
") End If strPath = GetImgPathWeb_Research(intYear, intMonth) strPath = strPath & "/" Dim objRs, sql set objRs = Server.CreateObject("ADODB.Recordset") sql = "select strWineCode, intYear_Make, strName_Kor, strName_Eng from " & strTable sql = sql & " where intNo_RS=" & intNo_RS & " order by strWineCode" objRs.open sql, objConn, 0,1,1 If objRs.Eof Then blnResult = False Else blnResult = True End If %> +W I N I E S* ¿ÍÀÌ´ÏÁî-¿ÍÀο¡ ¿­Á¤À» °¡Áø »ç¶÷µé
<% Call WriteSelectBox_Research(intNo_RS) %> <% Call WriteMagazineSubBanner(intYear, intMonth) %> <% Call WriteInfoSubBanner(intYear, intMonth) %>
<% ' Title Image If strImg_Title <> "" Then Response.Write "
" Response.Write "
" End If %>
<%=strWriter%>
<% If strImg_Content1 <> "" Then Response.Write "" End If Response.Write strIntro %>
<% ' Æò°¡ µÈ Wine List ------------------------------------------------------------------------------------- If blnResult Then %> <% Dim strWineCode, intYear_Make, strName_Kor, strName_Eng Dim intLoop, strColor intLoop = 2 Do While Not objRs.Eof strWineCode = objRs("strWineCode") intYear_Make = objRs("intYear_Make") strName_Kor = objRs("strName_Kor") strName_Eng = objRs("strName_Eng") If intLoop Mod 2 = 0 Then strColor = "#C9727E" Else strColor = "" End If %> <% objRs.MoveNext intLoop = intLoop + 1 If Not objRs.Eof Then %> <% End If Loop %>
Æò°¡¹øÈ£ Á¦Ç°¸í »ý»ê³âµµ
<%=strWineCode%> <%=strName_Eng%> (<%=strName_Kor%>) <%=intYear_Make%>
<% End If ' Æò°¡ µÈ Wine List End ------------------------------------------------------------------------------------- %>
<% objRs.Close Set objRs = Nothing Call DBClose() %>