Re: Sorting a recordset by a sum

"Jan Hyde" <StellaDrinker@xxxxxxxxxxxxxxxxxxx> wrote in message
news:d52uc295e8rm8o78ia70r073nrv87j5ekd@xxxxxxxxxx

Gave a similar error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Cannot group on fields
selected with '*' (c).

Do you have a GROUP BY in your SQL?

No, and that's part of the problem, which I see now. He wants to get away
without naming the columns (i.e., using *) but there's simply no way around
it when you have aggregate functions in your SELECT list.


.

Relevant Pages

  • Re: SQL INJECTION - ORACLE
    ... SQL INJECTION - ORACLE: ... > Microsoft OLE DB Provider for ODBC Drivers error '80040e14' ...
    (Pen-Test)
  • SQL INJECTION - ORACLE
    ... Microsoft OLE DB Provider for ODBC Drivers error '80040e14' ... This list is provided by the SecurityFocus Security Intelligence Alert ...
    (Pen-Test)
  • Re: OLEDB-Fehler beim Aufrufen von "ICommandText::Execute"
    ... Severity: 16 Source: Microsoft OLE DB Provider for SQL Server Error ... Server Error message: ...
    (microsoft.public.de.german.backoffice.smallbiz)
  • Re: SQL issue
    ... Microsoft OLE DB Provider for ODBC Drivers error '80040e14' ... DB provider instead of ODBC. ... Please reply to the newsgroup. ...
    (microsoft.public.scripting.vbscript)
  • Re: Drivers SQLSetConnectAttr failed
    ... Microsoft OLE DB Provider for ODBC Drivers error '80004005' ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)