|
|
|
|
¼ÄÄ / 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.
|
|
|
|