mothra
11-29-2004, 06:38 PM
This query produces the desired result in Access, but ASP does not like something about it. Anyone have any thoughts?
"SELECT COUNT(1), event FROM events GROUP BY event ORDER BY 1 DESC"
I have also tried modifying it slightly:
COUNT(*)
COUNT(*) as "whatever"
COUNT(event)
...etc...
This was my original problem: http://www.codingforums.com/showthread.php?p=253282#post253282
"SELECT COUNT(1), event FROM events GROUP BY event ORDER BY 1 DESC"
I have also tried modifying it slightly:
COUNT(*)
COUNT(*) as "whatever"
COUNT(event)
...etc...
This was my original problem: http://www.codingforums.com/showthread.php?p=253282#post253282