Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

database

Status
Not open for further replies.
spacehawk

spacehawk

Programmer
May 17, 2000
30
US
Is there a command in ASP that returns the number of records in a database table?
 
Sort by date Sort by votes
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
sql = &quot;SELECT count(*) AS RecordCount FROM table&quot;<br>rs.open sql, activeconnection<br><br>count = rs(&quot;RecordCount&quot;)<br>response.write count
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

penguinspeaks
  • Locked
  • Question
Parse a database field that is comma delimited and input the results into another table
Replies
0
Views
296
penguinspeaks
penguinspeaks
bslintx2021
  • Locked
  • Question
How to configure IIS 10 server to allow Classic ASP to connect to MSSQL server database on a domain
Replies
1
Views
739
penguinspeaks
penguinspeaks
leifoet
  • Locked
  • Question
How to update the content of radio buttons in a database?
Replies
2
Views
177
leifoet
leifoet
leifoet
  • Locked
  • Question
Problem with updating database reords.
2
Replies
31
Views
403
leifoet
leifoet
sdagger2
  • Locked
  • Question
Classic asp: Insert new record to access database from successful PayPal payment
Replies
2
Views
144
ChrisHirst
ChrisHirst

Part and Inventory Search

Sponsor

Back
Top