<% ConnectionString = "Provider=SQLOLEDB;Data Source=sql60.enterhost.com;Initial Catalog=BA321;user ID=BA321;password=walkerhilladm90 ;" Set GetDBConn = Server.CreateObject("ADODB.Connection") GetDBConn.Open(ConnectionString) %> Á¢¼ÓÅë°è
µðºñº¹±¸
À̸ÞÀϺ¸³»±â
Á¢¼ÓÅë°è
µµ¿ò¸»
¸Þ´º
<% y =request("y") If y="" Then y=year(now()) Else y =request("y") End If %>
Á¢¼ÓÅë°è
¸ÞÀÎÀ̹ÌÁö

³âµµ/¿ù ±×·¡ÇÁ Ŭ¸¯/¿äÀÏ
<%=y%>³â 1¿ù <% Set FindNum = GetDBConn.Execute("SELECT COUNT(lmonth) FROM E_log_visit where lyear='"&y&"' and lmonth='1'") LastNumber = FindNum(0) FindNum.close %>   <%If LastNumber < 601 Then %> <%=LastNumber%> <%Else %> <%=LastNumber%> <% End If %> <%=LastNumber%>
<%=y%>³â 2¿ù <% Set FindNum = GetDBConn.Execute("SELECT COUNT(lmonth) FROM E_log_visit where lyear='"&y&"' and lmonth='2'") LastNumber = FindNum(0) FindNum.close %>   <%If LastNumber < 601 Then %> <%=LastNumber%> <%Else %> <%=LastNumber%> <% End If %> <%=LastNumber%>
<%=y%>³â 3¿ù <% Set FindNum = GetDBConn.Execute("SELECT COUNT(lmonth) FROM E_log_visit where lyear='"&y&"' and lmonth='3'") LastNumber = FindNum(0) FindNum.close %>   <%If LastNumber < 601 Then %> <%=LastNumber%> <%Else %> <%=LastNumber%> <% End If %> <%=LastNumber%>
<%=y%>³â 4¿ù <% Set FindNum = GetDBConn.Execute("SELECT COUNT(lmonth) FROM E_log_visit where lyear='"&y&"' and lmonth='4'") LastNumber = FindNum(0) FindNum.close %>   <%If LastNumber < 601 Then %> <%=LastNumber%> <%Else %> <%=LastNumber%> <% End If %> <%=LastNumber%>
<%=y%>³â 5¿ù <% Set FindNum = GetDBConn.Execute("SELECT COUNT(lmonth) FROM E_log_visit where lyear='"&y&"' and lmonth='5'") LastNumber = FindNum(0) FindNum.close %>   <%If LastNumber < 601 Then %> <%=LastNumber%> <%Else %> <%=LastNumber%> <% End If %> <%=LastNumber%>
<%=y%>³â 6¿ù <% Set FindNum = GetDBConn.Execute("SELECT COUNT(lmonth) FROM E_log_visit where lyear='"&y&"' and lmonth='6'") LastNumber = FindNum(0) FindNum.close %>   <%If LastNumber < 601 Then %> <%=LastNumber%> <%Else %> <%=LastNumber%> <% End If %> <%=LastNumber%>
<%=y%>³â 7¿ù <% Set FindNum = GetDBConn.Execute("SELECT COUNT(lmonth) FROM E_log_visit where lyear='"&y&"' and lmonth='7'") LastNumber = FindNum(0) FindNum.close %>   <%If LastNumber < 601 Then %> <%=LastNumber%> <%Else %> <%=LastNumber%> <% End If %> <%=LastNumber%>
<%=y%>³â 8¿ù <% Set FindNum = GetDBConn.Execute("SELECT COUNT(lmonth) FROM E_log_visit where lyear='"&y&"' and lmonth='8'") LastNumber = FindNum(0) FindNum.close %>   <%If LastNumber < 601 Then %> <%=LastNumber%> <%Else %> <%=LastNumber%> <% End If %> <%=LastNumber%>
<%=y%>³â 9¿ù <% Set FindNum = GetDBConn.Execute("SELECT COUNT(lmonth) FROM E_log_visit where lyear='"&y&"' and lmonth='9'") LastNumber = FindNum(0) FindNum.close %>   <%If LastNumber < 601 Then %> <%=LastNumber%> <%Else %> <%=LastNumber%> <% End If %> <%=LastNumber%>
<%=y%>³â10¿ù <% Set FindNum = GetDBConn.Execute("SELECT COUNT(lmonth) FROM E_log_visit where lyear='"&y&"' and lmonth='10'") LastNumber = FindNum(0) FindNum.close %>   <%If LastNumber < 601 Then %> <%=LastNumber%> <%Else %> <%=LastNumber%> <% End If %> <%=LastNumber%>
<%=y%>³â11¿ù <% Set FindNum = GetDBConn.Execute("SELECT COUNT(lmonth) FROM E_log_visit where lyear='"&y&"' and lmonth='11'") LastNumber = FindNum(0) FindNum.close %>   <%If LastNumber < 601 Then %> <%=LastNumber%> <%Else %> <%=LastNumber%> <% End If %> <%=LastNumber%>
<%=y%>³â12¿ù <% Set FindNum = GetDBConn.Execute("SELECT COUNT(lmonth) FROM E_log_visit where lyear='"&y&"' and lmonth='12'") LastNumber = FindNum(0) FindNum.close %>   <%If LastNumber < 601 Then %> <%=LastNumber%> <%Else %> <%=LastNumber%> <% End If %> <%=LastNumber%>