´ç½Å¿¡°Ô·Î ¶°³ª´Â ²Þ¼Ó¿©Çà - ²Þ¼Ó³ª¶ó(http://www.inyourdream.net) ÀÔ±¹Çϱâ | ¿µÁÖ±Ç ½Åû
  • ¸öºÎ¸² °ñ¶ó°ñ¶ó
  • ¼Ò±Ù¼Ò±Ù
  • µµ¶õµµ¶õ
  • ³«¼­¸¶´ç
  • Âø°¢ÇѾÆÀÌ
  • ¼ýÀÚ¸ÂÃß±â
  • ¼Ò¿øºô±â
  • ÈçÀû³²±â±â
  • ²Þ¼Ó¿©Çà
  • Ä£±¸Áý ³î·¯°¡±â
  • ¸ðµÎµå¸²´ÔÀÇ È¨
  • î¤éÞ´ÔÀÇ È¨
  • Çö¿ì´ÔÀÇ È¨
  • º°¾ÆÇØ´ÔÀÇ È¨
  • ÇÞ»ì´ÔÀÇ È¨
  • À̳ª´Ï´ÔÀÇ È¨
  • À¯¸®¾Ë´ÔÀÇ È¨
  • ³È³ÈÀÌ´ÔÀÇ È¨
  • ²ÀÁö´ÔÀÇ È¨
  • ´ë¼º´ÔÀÇ È¨
  • ¼­ÄÄ / 2000-05-02 / ¿ÀÈÄ 10:56:24 / 203.253.213.164
    Á¶È¸¼ö : 157
    [Áú¹®] ´Ù½Ã ¶Ç ´Ù¸¥ ¿¡·¯°¡...y
    > > Àú¹ø¿¡ Áú¹®Çß´Ù°¡
    > > 俵´ÔÀÌ Á¹¸®´Ù°íÇϸç
    > > °£´ÜÈ÷ ¼³¸íÇØÁá´ø°Ô
    > > ÀÌÇØ°¡ ¾ÈµË´Ï´Ù.
    > >
    > > group by ¸¦ »ç¿ëÇÏ¸é µÈ´Ù°í Çϼ̴µ¥...
    > > ÀÚ¼¼È÷ ¾î¶»°Ô ÇØ¾ß Çϴ°ÇÁö...
    > >
    > > <%
    > >
    > > 'DB¿¡ ¿¬°á
    > > Set db = Server.CreateObject("ADODB.Connection")
    > > db.Open("DSN=SiteDataDB;UID=sa;PWD=")
    > >
    > > SQL= "SELECT * FROM w2k GROUP BY cat ORDER BY num DESC"
    > >
    > > Set rs = Server.CreateObject("ADODB.Recordset")
    > > rs.Open SQL,db,0
    > >
    > > %>
    > > ÀÌ·¸°Ô Çؼ­ ¿¬°áÇØ ºÃ´Âµ¥ ¿¡·¯°¡ °è¼Ó ³ª³×¿ä..
    > > Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
    > > [Microsoft][ODBC SQL Server Driver][SQL Server]Column 'w2k.w2k_id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
    > >
    > >
    > >
    > >
    > >
    > -----------------------------------------------------------
    >
    > SELECT¹®À»
    >
    > SQL= "SELECT cat FROM w2k GROUP BY cat ORDER BY num DESC"
    >
    > ÀÌ·¸°Ô ¹Ù²ã º¸¼¼¿ä~~
    >
    > Ä«¿îÆ® ¼Ò½º¸¦ º¸½Ã¸é group by¿¡ ´ëÇÑ »ç¿ë¹ýÀ» ¾Æ½Ç¼ö ÀÖÀ»°Å¿¹¿ä....
    >
    >
    -----------------------------------------------------------
    ±×·¸°Ô ¹Ù²Ù¾ú´õ´Ï ´Ù½Ã ÀÌ·± ¿¡·¯°¡...ÂÁ

    Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
    [Microsoft][ODBC SQL Server Driver][SQL Server]Column name 'w2k.num' is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause.


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