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 derfloh 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
Joined
May 17, 2000
Messages
30
Location
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 Question
Parse a database field that is comma delimited and input the results into another table
Replies
0
Views
723
penguinspeaks
penguinspeaks
bslintx2021
  • Locked
  • Question Question
How to configure IIS 10 server to allow Classic ASP to connect to MSSQL server database on a domain
Replies
1
Views
1K
penguinspeaks
penguinspeaks
leifoet
  • Locked
  • Question Question
How to update the content of radio buttons in a database?
Replies
2
Views
512
leifoet
leifoet
leifoet
  • Locked
  • Question Question
Problem with updating database reords.
2
Replies
31
Views
2K
leifoet
leifoet
sdagger2
  • Locked
  • Question Question
Classic asp: Insert new record to access database from successful PayPal payment
Replies
2
Views
454
ChrisHirst
ChrisHirst

Part and Inventory Search

Sponsor

Back
Top