CFF KB - Carrz-Fox-Fire Promotions Knowledge Base

 CFF KB is all about 1 thing: The Sharing of Knowledge and the Power we gain from it.
  • Breadrumbs:

  • Microsoft OLE DB Provider for SQL Server (0x80040E14) Column ' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause

    • CFF Knowledge Base - Share With Facebook CFF Knowledge Base - Share on Twitter CFF Knowledge Base - Share on Reddit CFF Knowledge Base - Share on Digg It CFF Knowledge Base - Share on Stumble Upon It CFF Knowledge Base - Share on Delicious
    Share With Friends (Updated 6-8-2010)
  • Article ID:
    78
  • Date Created
    Friday, December 24, 2010
  • This Article Has been Viewed
    1934 times
  • Short Desc
    When you build a SQL Statement with a Count and have other Columns that are used in the Statement, you must include then in a GROUP BY clause.
  • Details
    When you build a SQL Statement with a Count and have other Columns that are used in the Statement, you must include then in a GROUP BY clause. If you do not include the other Columns, you will receive the following error.

     
    Microsoft OLE DB Provider for SQL Server (0x80040E14)
    Column 'pics.PicsName' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
    /Results.asp, line 71
  • Recreate Issue
    To recreate this error.

    <%
    getPics.commandtext="SELECT COUNT(thID) AS count, Name, Path, Pic from pics where id=?"
    %>
  • Resolve Issue
    To correctly write this Statement.

    <%
    getPics.commandtext="SELECT COUNT(thID) AS count, Name, Path, Pic from pics GROUP BY Name, Path, Pic HAVING id=?"
    %>


    As you can see in the example above, we have added all the Columns that are used in our GROUP BY clause.

Recent Articles

All Topics

  • Coming Soon - Knowledge Exchange

Trending Articles