title: how to count records in ASP classic?
body: <p>I'm not quite familiar with programming ASP classic. I just need a small code to run on my webpage. How do i count the record of the returned query?</p>
  
  <pre><code>&lt;%
  Set rsscroll = Server.CreateObject("ADODB.Recordset")
  Dim strSQLscroll, rsscroll
  strSQLscroll = "SELECT * FROM tblItems where expiration_date &gt; getdate() order by expiration_date desc;"
  rsscroll.open strSQLscroll,oConn
  %&gt;
  </code></pre>
  
  <p>thanks,</p>