May 29, 2000 #1 spacehawk Programmer Joined May 17, 2000 Messages 30 Location US Is there a command in ASP that returns the number of records in a database table?
May 30, 2000 #2 NickBulka Programmer Joined Aug 10, 1999 Messages 832 Location US select count(*) from tablename<br> <p>nick bulka<br><a href=mailto:nick@bulka.com>nick@bulka.com</a><br><a href= > </a><br> Upvote 0 Downvote
select count(*) from tablename<br> <p>nick bulka<br><a href=mailto:nick@bulka.com>nick@bulka.com</a><br><a href= > </a><br>
May 30, 2000 #3 LuvASP Programmer Joined May 18, 2000 Messages 46 Location US sql = "SELECT count(*) AS RecordCount FROM table"<br>rs.open sql, activeconnection<br><br>count = rs("RecordCount"<br>response.write count Upvote 0 Downvote
sql = "SELECT count(*) AS RecordCount FROM table"<br>rs.open sql, activeconnection<br><br>count = rs("RecordCount"<br>response.write count