Count specific records from an existing recordset without using the select count method (Classic ASP / VBScipt)

I have a recordset from an sql query, from which I get the following result:

 ---------------
| Column_Color  |
|---------------|
| Blue          |
| Red           |
| Magenta       |
| Red           |
| Grey          |

Open in new window

As you can see, I have 2 records with the RED color.

I wonder if there is any possible way or method to count all the records having the RED color, from the column Column_Color ?

I am trying to avoid creating a new query with the SELECT COUNT method and I want to know if there is any possible method to count the RED colors, from the existing recordset. The desired result is to have the number 2 as a result.
Vasilis DimitrakasAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
slightwv (䄆 Netminder) Commented:
My VBScript and Classic ASP skills are really old and rusty but I always start by looking at what options might help me get what I want.

I'm guessing you are dealing with a recordset?

I started here:
https://docs.microsoft.com/en-us/sql/ado/reference/ado-api/recordset-object-ado

More summarized list of what is available:
https://www.w3schools.com/asp/ado_ref_recordset.asp

That gets me to the Filter property that seems to be what I'm looking for.

I already know there are a couple ways to get a Count of things so then I just need to go looking.

Found this:
https://docs.microsoft.com/en-us/sql/ado/reference/ado-api/filter-and-recordcount-properties-example-vb
0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.