´ç½Å¿¡°Ô·Î ¶°³ª´Â ²Þ¼Ó¿©Çà - ²Þ¼Ó³ª¶ó(http://www.inyourdream.net)
ID¿Í Password¸¦ ÀÔ·ÂÇϼ¼¿ä.
ÀÔ±¹Çϱâ
|
¿µÁÖ±Ç ½Åû
¸öºÎ¸² °ñ¶ó°ñ¶ó
¼Ò±Ù¼Ò±Ù
µµ¶õµµ¶õ
³«¼¸¶´ç
Âø°¢ÇѾÆÀÌ
¼ýÀÚ¸ÂÃß±â
¼Ò¿øºô±â
ÈçÀû³²±â±â
²Þ¼Ó¿©Çà
Ä£±¸Áý ³î·¯°¡±â
¸ðµÎµå¸²´ÔÀÇ È¨
î¤éÞ´ÔÀÇ È¨
Çö¿ì´ÔÀÇ È¨
º°¾ÆÇØ´ÔÀÇ È¨
ÇÞ»ì´ÔÀÇ È¨
À̳ª´Ï´ÔÀÇ È¨
À¯¸®¾Ë´ÔÀÇ È¨
³È³ÈÀÌ´ÔÀÇ È¨
²ÀÁö´ÔÀÇ È¨
´ë¼º´ÔÀÇ È¨
µî·ÏÇϽǶ§´Â ÇʼöÇ׸ñÀ» ¸ðµÎ ÀÔ·ÂÇÏ¼Å¾ß ÇÕ´Ï´Ù.
À̸§
*
HTML »ç¿ë
Á¦¸ñ
*
¼±ÅÃ
ÀÚÀÛ
»ç¶û
À¯¸Ó
ÀÚÀ¯
̵̧
¾Ë¸²
Áú¹®
±âŸ
³»¿ë
*
> <%@ 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ºÎºÐÀº ³â¿ùÀÏ Àüü¸¦ ³ªÅ¸³»´Â °Í ¾Æ´Ñ°¡¿ä? > (ÇÏÁö¸¸ °íÃļ Çصµ ¶È°°Àº ¿¡·¯°¡...) > > ¼³¸í ºÎŹµå¸³´Ï´Ù.. > ±ÍÂú°Ô Çؼ Á˼ÛÇÏ°í. Áß¿äÇÑ ÀÏÀÌ¶ó¼ ±×·¯´Ï ²À Á» µµ¿òÀ» Áֽʽÿä > > -----------------------------------------------------------
Ãß°¡ÇÒ À̹ÌÁö¸¦ ÀÔ·ÂÇϼ¼¿ä.
À̹ÌÁö 1
À̹ÌÁö¼³¸í 1
Ãß°¡ÇÒ ÀڷḦ ÀÔ·ÂÇϼ¼¿ä.
ÀÚ·á 1
ÀÚ·á¼³¸í 1
Ãß°¡ÇÒ ½ÎÀÌÆ®¸¦ ÀÔ·ÂÇϼ¼¿ä.
°ü·Ã½ÎÀÌÆ® 1
½ÎÀÌÆ®¼³¸í 1
Password
*