How can i get the number of rows returned in a recordset without using the recordset.count method? Is there a way to get it by using SQL? I need to get this information in the context of a stored procedure.
Select Count(*) as cnt from Table....<BR><BR>set rs = ...<BR><BR>Number of records returned: <%= rs("cnt") %>
Thanks, Mike. That little bit helped a whole lot.