|
|
|
|
 |
|
꼭지 / 2001-12-20 / 오전 10:33:37 / 147.6.140.128
조회수 : 130
|
| [질문] DataCommand1.Open .......
|
<%
P_Year = Year(date)
P_Month = Month(date)
If P_Month < 10 Then
P_Month = "0" & P_Month
End If
P_Day = Day(date)
If P_Day < 10 Then
P_Day = "0" & P_Day
End If
Set DBConnection = Server.CreateObject("ADODB.Connection")
DBConnection.Open Session("DBConnection_ConnectionString"), Session("DBConnection_RuntimeUserName"), Session("DBConnection_RuntimePassword")
strQuery = "SELECT Count(*) FROM T_DreamCount_M WHERE C_Year_N='"&P_Year&"' AND C_Month_N='"&P_Month&"' AND C_Day_N='"&P_Day&"'"
Set objRs = DBConnection.Execute(strQuery)
V_Today = objRs(0)
objRs.Close
Set objRs = Nothing
%> |
|
|
