Partial Record Count

[toddsalcedo]

I have a table, fed from a database, that shows 29 items. I need to break that down further by splitting out the 29 items into different categories. The problem is that one of the items is multiple words and my count function breaks at that point. Here's the code:

<%
if RS("status") = "Resolution of Comments" then
do while RS("status") = "Resolution of Comments"
counter5=counter5+1
%>
<%RS.movenext
loop
end if
%>

There are 10 counter sections in all, all of them counting different rows of the table. Any ideas of a better way to try and count this?

 

[EBGreen]

If they are all based on the RS("status") field, then I would use a Select Case Statement. Something like this:

<%
Select Case RS("status")
  Case "Resolution of Comments"
    counter5 = counter5 + 1
  Case "Other Thing"
    counterOther = counterOther + 1
  Case Else
    'Do something here to handle anything that is outside your criteria
End Select

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]