|
|
|
|
¹Ú°¡·ç / 2001-12-20 / ¿ÀÀü 10:22:51 / 210.178.30.238
Á¶È¸¼ö : 130
|
[Áú¹®] DataCommand1.Open ....... |
<%@ LANGUAGE="VBSCRIPT" %>
<%
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
P_Date = P_Year & "-" & P_Month & "-" &P_Day
%>
<%
Set DBConnection = Server.CreateObject("ADODB.Connection")
DBConnection.ConnectionTimeout = Session("DBConnection_ConnectionTimeout")
DBConnection.CommandTimeout = Session("DBConnection_CommandTimeout")
DBConnection.Open Session("DBConnection_ConnectionString"), Session("DBConnection_RuntimeUserName"), Session("DBConnection_RuntimePassword")
Set cmdTemp = Server.CreateObject("ADODB.Command")
Set DataCommand1 = Server.CreateObject("ADODB.Recordset")
cmdTemp.CommandText = "Select * From T_DreamCount_N Where C_Day_N=" '"& P_Date &"'
cmdTemp.CommandType = 1
Set cmdTemp.ActiveConnection = DBConnection
DataCommand1.Open cmdTemp, , 1, 1
V_Today=DataCommand1.RecordCount
%>
¿À´Ã ¹æ¹®ÀÚ¼ö´Â
<%=V_Today %>
ÀÔ´Ï´Ù
¿À´ÃÀÇ ³¯Â¥´Â
<%=Day(date) %>
ÀÔ´Ï´Ù.
¼Ò½º¸¦ ÀÌ·¸°Ô ÀÛ¼ºÇÏ°í ½ÇÇà½ÃÄ×´õ´Ï
[ DataCommand1.Open cmdTemp, , 1, 1 ]
ÀÌ ºÎºÐ¿¡¼ odbcµå¶óÀ̹ö°¡ ¿äûÇÑ ¼Ó¼ºÀ» Áö¿øÇÏÁö ¾Ê½À´Ï´Ù.¶ó´Â ¿¡·¯°¡ ¶å´Ï´Ù..
ÀÚ²Ù ¶È°°Àº Áú¹®À¸·Î ±«·ÓÇô¼ Á˼ÛÇÕ´Ï´Ù..
ºÎµð ÇÑ ¹ø¸¸ ´õ ´äº¯À» ÇØ Áֽʽÿä.
±ÞÇÑ ÀÏÀ̶ó¼....ÀÌ¿ÕÀ̸é À§¿¡ ¼Ò½ºµµ Á» ¼öÁ¤ÇØ Áֽðí¿ä..
Âü°í·Î db´Â ¿¢¼¼½º2000¸¦ »ç¿ëÇÏ°í odbcµå¶óÀ̹ö ´Ù Àâ¾Ò½À´Ï´Ù..
ÇÑ°¡Áö ±Ã±ÝÇÑ Á¡ÀÌ Àִµ¥ Where C_Day_N=" '"& P_Date &" ÀÌ ºÎºÐ¿¡¼ c_day_nÀº ´ÜÁö ³¯Â¥¸¸ ³ªÅ¸³»°í,P-DateºÎºÐÀº ³â¿ùÀÏ Àüü¸¦ ³ªÅ¸³»´Â °Í ¾Æ´Ñ°¡¿ä?
(ÇÏÁö¸¸ °íÃļ Çصµ ¶È°°Àº ¿¡·¯°¡...)
¼³¸í ºÎŹµå¸³´Ï´Ù..
±ÍÂú°Ô Çؼ Á˼ÛÇÏ°í. Áß¿äÇÑ ÀÏÀÌ¶ó¼ ±×·¯´Ï ²À Á» µµ¿òÀ» Áֽʽÿä
|
|
|
|