I have a certain amount of records (30) and I want to show a number that will be minus that records number. Like that:<BR><BR>30 members - 70 members left (out of 100)<BR><BR>How can I do it?
Try googling for "recordset paging".
What I need to know is how can I count records from a database and then, to minus that number from a number that I have.
numberyouhave = 100<BR>numberfromdb = rs("number")<BR>newnumber = numberyouhave - numberfromdb<BR>response.write(newnumber)<BR><BR>s imple maths really. which part dont you understand?<BR>
.. is how to get the number available...<BR><BR>sql = "select count(id) from table"<BR>set rs_count = connection.execute(sql)<BR>numberyouhave = rs_count(0)