|
|
|
|
|
| | |
| |
Active Server Pages ASP ASP.NET .aspx .ascx Web HTML Developer Internet Microsoft Web Services Visual Studio .NET CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
aggregate function |
|
From: |
Itwebguy |
|
Date: |
8/27/2001 8:32:31 AM |
|
IP: |
209.128.29.254 |
Why does this sql not work in my asp page??
sqlstmt = "SELECT Sum(hits) AS [hit], counter.page FROM counter ORDER BY counter.page"
I get this error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access 97 Driver] You tried to execute a query that doesn't include the specified expression 'page' as part of an aggregate function.
/tester.asp, line 17
Any ideas??
ITWG |
Follow Up - Re: aggregate function - Elija 9/4/2001 9:29:21 AM
Follow Up - Re: aggregate function - seb 4/24/2002 2:01:48 PM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
