|
|
|
|
²ÀÁö / 2001-12-20 / ¿ÀÀü 1:17:16 / 211.38.169.66
Á¶È¸¼ö : 128
|
[Áú¹®] ¾Ë·Á ÁÖ¼¼¿ä.....
|
> ¹Ø¿¡ ¾î´À ´ÔÀΰ¡ ,,,,俵´ÔÀÇ ¼Ò½º ±â¹ÝÀ§¿¡¼ ÃÑ ¹æ¹®
> ÀÚ ±¸ÇÏ´Â ¹ý¿¡ ´ëÇؼ ¹°¾îº¸½Å°Å º¸°í
> 俵´Ô ¸»´ë·Î Á¤¼ö´ÔÀÇ ±ÛÀ» Àо¾Ò½À´Ï´Ù..
>
> ´Ù Àаí ÀÌÇصµ ÀßµÇ°í ¾Ë°Ú´Âµ¥ ., Àüü ¹æ¹®ÀÚ°¡ ¾Æ´Ñ
> ¿À´ÃÀÇ ¹æ¹®ÀÚ¸¦ ±¸ÇÏ´Â ºÎºÐÀ» ±¸ÇÏ·Á°í
> ÄÚµùÀ» Çغ¸¾Ò½À´Ï´Ù.
> Select * From T_DreamCount_N
> Where C_Day_N=" &Day(date)
> ±×¸®°í ·¹ÄÚµå Ä«¿îÆ®¸¦ µ¹·È´Âµ¥
> cmdtempºÎºÐ¿¡¼ °³Ã¼ ¼³Á¤ÀÌ À߸øµÇ¾ú´Ù´Â ¿¡·¯ ¸Þ¼¼Áö°¡ ¶å´Ï´Ù.
>
> ±×¸®°í À§¿¡Ã³·³ÀÌ ¾Æ´Ñ
> WhereºÎºÐÀ» »©¹ö¸®¸é (Á¤¼ö´ÔÀÇ ¼Ò½º±×´ë·Î)
> Àß µÇ°í¿ä...ÀÌÀ¯¸¦ Àß ¸ð¸£°Ú½À´Ï´Ù..Á¦°¡ ½Ç¼öÇÑ °Å¶óµµ.. ²À Á» °¡¸£ÃÄ Áֽʽÿä.
> ±×¸®°í µÉ¼ö ÀÖÀ¸¸ç ±× ºÎºÐÀÇ ÄÚµùÀ» Á» ÇØÁֽʽÿä,,
>
> ¾ÆÁ÷ ¹ÌÈíÇÑ Ãʺ¸¶ó¼ ...º¸°í °øºÎÇÒ ¼ö ÀÖµµ·Ï ²À Á» ºÎŹµå¸³´Ï´Ù..
>
> ±×¸®°í ²Þ¼Ó³ª¶ó Ä«¿îÅÍ¿¡¼ Ãʱâȸ鿡 ¿À´ÃÀÇ ¹æ¹®ÀÚ¼ö ³ª¿À´Â ºÎºÐ ¼Ò½º º¸°íµµ Àß ÀÌÇØ°¡ °¡Áö ¾Ê´õ±º¿ä,,
> ±×ºÎºÐ¿¡ ´ëÇؼµµ ¼³¸íÀ»Á» ÇØ Áֽʽÿä,,
>
> ¹Ù»Ú½Å ºÐÇÑÅ× ³Ê¹« ¹«¸®ÇÑ ºÎŹÀ» ÇÏ´Â°Ô ¾Æ´ÑÁö ¸ð¸£°Ú±º¿ä..
>
> ¾ÆÁ÷ ÀÇ¿åÀº ¸¹Àºµ¥ ½Ç·ÂÀÌ ºÎÁ·Çؼ ²À Á» ¾Ë°í ½Í½À´Ï´Ù...²Ù¹÷²Ù¹÷
>
>
>
-----------------------------------------------------------
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
ÀÌ·¸°Ô Çؼ ³¯Â¥Çü½ÄÀÇ º¯¼ö¸¦ »ý¼º½ÃŲ ´ÙÀ½¿¡
Select * From T_DreamCount_N
Where C_Day_N= '"& P_Date &"'
ÀÌ·¸°Ô Çؼ Äõ¸® ³¯¸®¸é °á°ú ³ª¿Ã°Ì´Ï´Ù..
|
|
|
|