´ç½Å¿¡°Ô·Î ¶°³ª´Â ²Þ¼Ó¿©Çà - ²Þ¼Ó³ª¶ó(http://www.inyourdream.net) ÀÔ±¹Çϱâ | ¿µÁÖ±Ç ½Åû
  • ¸öºÎ¸² °ñ¶ó°ñ¶ó
  • ¼Ò±Ù¼Ò±Ù
  • µµ¶õµµ¶õ
  • ³«¼­¸¶´ç
  • Âø°¢ÇѾÆÀÌ
  • ¼ýÀÚ¸ÂÃß±â
  • ¼Ò¿øºô±â
  • ÈçÀû³²±â±â
  • ²Þ¼Ó¿©Çà
  • Ä£±¸Áý ³î·¯°¡±â
  • ¸ðµÎµå¸²´ÔÀÇ È¨
  • î¤éÞ´ÔÀÇ È¨
  • Çö¿ì´ÔÀÇ È¨
  • º°¾ÆÇØ´ÔÀÇ È¨
  • ÇÞ»ì´ÔÀÇ È¨
  • À̳ª´Ï´ÔÀÇ È¨
  • À¯¸®¾Ë´ÔÀÇ È¨
  • ³È³ÈÀÌ´ÔÀÇ È¨
  • ²ÀÁö´ÔÀÇ È¨
  • ´ë¼º´ÔÀÇ È¨
  • 俵ÀÌ / 2001-02-06 / ¿ÀÈÄ 7:45:47 / 203.255.3.190
    Á¶È¸¼ö : 191
    [Áú¹®] »ýÀÏÀÏÀ» ±¸ÇöÇÒ·Á±¸ Çϴµ¥.....
    > ============================================
    >
    > Set DbCon = Server.CreateObject("ADODB.Connection")
    > DbCon.Open "ABC", "sa", ""
    >
    > SQLstmt2 = "SELECT id,userid,username,sex,idnumber FROM member order by id desc "
    > Set DbRec=Server.CreateObject("ADODB.RecordSet")
    > DbRec.Open SQLstmt2, DbCon,1
    >
    >
    > strMonth = cint(Month(now))
    > strDay = cint(Day(now))
    >
    > if cint(strMonth) < 10 then
    > strMonth = "0" & strMonth
    > end if
    >
    > if cint(strDay) < 10 then
    > strDay = "0" & strDay
    > end if
    >
    > today = strMonth & strDay
    >
    > if not DbRec.eof then
    >
    > for j=1 to ucount
    >
    > if j MOD 2 = 0 then
    > Response.Write ""
    > Response.Write ""
    >
    > else
    >
    > Response.Write ""
    > Response.Write ""
    >
    > end if
    >
    > aaa=left(DbRec(4),6)
    > bbb=right(aaa,4)
    >
    >
    > Response.Write " "
    > Response.Write ""&DbRec(2)&""
    > Response.Write "("&DbRec(3)&")"
    >
    > DbRec.MoveNext
    >
    > next
    > else
    > Response.Write ""
    > Response.Write "¿À´Ã »ýÀÏÀλç¶÷ÀÌ ¾ø±º¿ä!"
    >
    > end if
    > DbRec.Close
    >
    > ================================================
    > º°¾ÆÇØ´ÔÀÇ »çÀÌÆ®¿¡º¸ÀÌ´Â »ýÀÏÀÏÀ» ±¸ÇöÇÒ·Á±¸Çϴµ¥¿ä~
    > ÁֹιøÈ£¸¦ äŷÇؼ­ »ý³â¿ùÀÏÀ» ±¸ÇÒ·Á±¸¿ä.
    >
    > ±Ùµ¥ ¹®Á¦°¡¿© ÁֹιøÈ£ ¾ÕÀÚ¸®°¡ 6ÀÚ¸® Àݾƿä
    > µÚ¿¡ 4ÀÚ¸®¸¸Àº(À§ÀÇ bbb) ±¸ÇÒ¼öÀִµ¥....
    >
    > ÀÌ ±¸ÇÑ4ÀÚ¸®¸¦ ÇöÀç ³¯Â¥¿Í °°´Ù¸é, º¸¿©ÁÖ°í
    > ¾Æ´Ï¸é ¾Èº¸¿©ÁÖ°Ô ¸¸µé·Á´Âµ¥....
    >
    > Àß ¾ÈµÅ³×¿ä^^
    > if¹®À» for¹® ¾È¿¡ ³ÖÀ¸´Ï±ñ next°¡ ÇÊ¿äÇÏ´Ù°í ¿¡·¯³ªµ¥¿ä....
    > ¾îÄÉÇÏ¸é µÅÁÒ,,,,????
    > ÂÁ,,, ¾îÁ¦ ¹¯°í ¿À´Ã ¶Ç ¹¯°í,,, ¸Ç³¯ ¹¯´Â¸ÇÀÓ´Ù,,,
    > ¸Ó¸®´Â ³ª»Ú°í,¾î·ÁÇÂ,,,ASP¸¦ ÇÒ·Á´Ï... ¹ÌÄ¡°Ú¾î¿ä!
    > ¿ÕASPÀÇ Ã¤¿µÀÌ´Ô... ºÎŹµå¸³´Ï´Ù,,,
    >
    > ±×·¡µµ ¿©±âÀú±â Ÿ »çÀÌÆ® º¸´Ù,,,
    > ¿©±â ²Þ¼Ó³ª¶ó°¡ ÃÖ°í·Î ´äº¯À̺ü¸£°í,,,ÀßÇØ°áµÇ´Â°Í °°¾Æ¿ä.Àú°°ÀÌ ¿ÕÃʺ¸¿¡°Õ ÀÌ·±»çÀÌÆ®°¡ ¾ó¸¶³ª
    > Å« µµ¿òÀÌ µÇ´ÂÁö...
    >
    > ¾î¶»°Ô º¸´äÀ»ÇÏÁö....
    >
    > ¾ÆÂü Àú,,, PC¹æ Â÷¸±Áö ¸ô¶ó¿ä,,,,
    > Æ÷Ç׿¡ »ì°Åµç¿ä,,,
    > Æ÷Ç׿À½Ã¸é,,, °×ºñ ¹«·á,,,,^^ (俵ÀÌ´Ô¸¸¿©) ¤»¤»
    >
    >
    -----------------------------------------------------------

    ¼Ò½º°¡ ¾îÂî µÈ°ÇÁö Á¤È®È÷ ¸ð¸£°Ú¾î¿ä... ^^;

    ȸ¿øµéÀ» ÀüºÎ »Ì¾Æ¼­ Áֹεî·Ï¹øÈ£¶û ¿À´Ã³¯Â¥¶û ºñ±³Çؼ­

    »ýÀÏÀÎ »ç¶÷À» 2ÁÙ·Î »Ñ·ÁÁֽ÷Á°í ÇϽô °Ç°¡¿ä?

    ÀÌ·¸°Ô SQL ±¸¹®À» °íÃĺ¸¸é ¾î¶³±î¿ä?

    Áֹεî·Ï¹øÈ£¿¡ ¿À´Ã³¯Â¥°¡ µé¾î°¡ ÀÖ´Â »ç¶÷¸¸À» SELECT Çϵµ·Ï ¸»ÀÌÁö¿ä...

    strMonth = cint(Month(now))
    strDay = cint(Day(now))

    if cint(strMonth) < 10 then
    strMonth = "0" & strMonth
    end if

    if cint(strDay) < 10 then
    strDay = "0" & strDay
    end if

    today = strMonth & strDay

    SQLstmt2 = "SELECT id, userid, username, sex, idnumber FROM member WHERE idnumber LIKE '__"&today&"%' ORDER BY id DESC"

    LIKE ±¸¹®À» ÀÀ¿ëÇؼ­¿ä...

    ÁֹιøÈ£ÀÇ ¾ÕÀÇ 2ÀÚ¸®´Â ¾Æ¹«°Å³ª ¿À°í ±×´ÙÀ½¿¡ ¿À´Â

    4ÀÚ¸®°¡ ¿À´Ã³¯Â¥¿Í °°°í

    ±×¸®°í µÚÀÇ ÀÚ¸®´Â ¾Æ¹«°Å¶óµµ »ó°üÀÌ ¾ø°Ô¾ø±¸¿ä...

    ÀÌ·¸°Ô ÇÏ¸é ¸¸¾à¿¡ ¿À´ÃÀÌ 02¿ù 05ÀÏ¿¡

    ÁֹιøÈ£°¡ 710412-2020512°°Àº °æ¿ì °°ÀÌ

    µÚ¿¡ 7ÀÚ¸®¿¡´Â ¿À´Ã ³¯Â¥°¡ µé¾î ÀÖ´õ¶óµµ SELECT µÇÁö ¾Ê°í...

    ¹Ù·Î µÇ°ÚÁö¿ä... ±×·³....

    Ȥ... Æ÷Ç׿¡ °¡¼­ ÇÒÀÏÀÌ ¾øÀ¸¸é ½Ã°£ ¶§¿ï°÷Àº »ý°å³×¿ä.... ÈÄÈÄ...

    Byte * 200 Byte À̳»·Î ÀÔ·ÂÇϼ¼¿ä À̸§ : Æнº¿öµå :