I'm trying to implement a pagination feature in my search page and I'm wondering how I can get and use the value that's returned from this SQL statement:
SELECT COUNT(*) FROM TableName WHERE Assigned = 'name'
I've run this query in the database query analyzer and it returned 19 however when I attempt the code on my page I get a 500 error.
Here's the page code:
Set row = conn.Execute("SELECT COUNT(*) FROM TableName WHERE Assigned = 'Name'")
<div id="resultTest"> <%=row%> </div>