|
|
|
|
|
| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
