Classic ASP Discussion

Print Page | Close Window

DB Query

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=5825
Printed Date: 30 March 2026 at 11:40pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: DB Query

Posted By: ldiuf
Subject: DB Query
Date Posted: 18 September 2003 at 12:56pm

I was wondering how I would query a db for some stats. In other words, count how many entries in the DB that have a certain defined aspect, and then it spits the result out in numerical form. I.e. "There are 37 instances of ??? found in field ??? of the DB and 42 instances found in field ??? for a total of or difference of ??? in the database (access2000)"

That's pretty much what I want to try to do. Any pointers or tutorials or just plain already done, anything, would be great.

Thanks in advance.

Larry

ldiuf@hotmail.com

Replies:

Posted By: Flamewave
Date Posted: 19 September 2003 at 12:24pm

Try using the COUNT() method.
http://www.w3schools.com/sql/func_count_ast.asp - http://www.w3schools.com/sql/func_count_ast.asp

-------------
- Flamewave

They say the grass is greener on the other side, but if you really think about it, the grass is greener on both sides.