Hello evryone.

I want to display a number counting from 1 till the amount of records in my db. How can I do this with recordset count???

need help tnx....

peace

__________________
-------------------------
peace, luv and respect

The recordset.count will only count the number of rows of data returned to you via your query (depending on your query this may or may not be the actual number of rows of data in your database).

This article might help you:
http://www.asp101.com/samples/viewas...%5Fcount%2Easp

That is a zero-based count so you would have to set the value of recordcount to a variable and add 1 to it, or you could simply execute this query:

SELECT count(field) from table

Where field is any column in your table and it will return you the number of rows that exist in the table.

hth

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

Yeah tnx for replying, I already saw that article but I couldn't figure out the codes. First I used the code as it is and it doen't display a thing -> full blank page. Then I changed the DB_CONNSTRING and no success.

I use iis on my local machine.

How can I still do it with this code??

One more thing what I wanted was this:

e.g.
Members
1 John
2 Mary
3 Edward
4 Raymond
5 Sally

And the numbers 1 till 5 is the asp code, they are not derived from the database but the names are well derived from the db.

When I saw the db of the article and the output of the sample it doent looked like what I wanted to do.

My english aint 100% if you didnt understand me let me know.......

One more time tnx..

Since you want that just do this:

Dim iIndex

iIndex = 1
While Not rs.eof
   response.write iIndex & " " & rs("field")
   iIndex = iIndex + 1
Wend

hth.

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

dparsons tnx

that was exactly the the code I was looking for, do you know how you can let it keep counting when you use paging.

Here's my code:

Dim iIndex
iIndex = 1

For i=1 To 25
If Not rsMiembro.eof And Not rsMiembro.bof Then

       'Write the HTML to display the current record in the recordset
    Response.Write ("<tr><td>")
    Response.Write iIndex
    Response.Write ("</td>")
    Response.Write ("<td width=10>&nbsp;</td>")
    Response.Write ("<td>")
    Response.Write (rsMiembro("nomber"))
    Response.Write ("</td>")
    Response.Write ("<td width=10>&nbsp;</td>")
    Response.Write ("<td>")
    Response.Write (rsMiembro("fam"))
    Response.Write ("</td>")
    Response.Write ("</tr>")
    iIndex = iIndex + 1
    'Move to the next record in the recordset
    rsMiembro.MoveNext
End If
Next

   Response.Write ("</table>")
   Response.Write ("</form>")


Response.Write "<p><table><tr>"
For i=1 To rsMiembro.PageCount
Response.Write "<td><a href='memb_del.asp?pg=" & i & "'><div class='pglink'>" & i & "</div></a>"
Next


peace, luv and respect

I've found this code but how can I put a loop into it:

Dim iIndex
iIndex = 1
if rsMiembro.AbsolutePage=2 then iIndex=26
if rsMiembro.AbsolutePage=3 then iIndex=51
if rsMiembro.AbsolutePage=4 then iIndex=76

For i=1 To 25
If Not rsMiembro.eof And Not rsMiembro.bof Then

etc....

peace, luv and respect

What do you mean?

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

With the code that you gave me:
Dim iIndex
iIndex = 1
While Not rs.eof
   response.write iIndex & " " & rs("field")
   iIndex = iIndex + 1
Wend
I get this on my page:
http://c.1asphost.com/nouky/miembro2.asp

With this code:
Dim iIndex
iIndex = 1
if rsMiembro.AbsolutePage=2 then iIndex=26
if rsMiembro.AbsolutePage=3 then iIndex=51
if rsMiembro.AbsolutePage=4 then iIndex=76
For i=1 To 25
If Not rsMiembro.eof And Not rsMiembro.bof Then
etc....

I get this output:
http://c.1asphost.com/nouky/miembro.asp

My question is how can I prevent writing this code or convert it into a LOOP:
if rsMiembro.AbsolutePage=2 then iIndex=26
if rsMiembro.AbsolutePage=3 then iIndex=51
if rsMiembro.AbsolutePage=4 then iIndex=76

Because each time I have to write a new line when I add more people to the database.My question is how can I convert the code in a Loop??



-------------------------
peace, luv and respect

Your webserver is refusing my connection and I can't view what you your examples (I will look at them when i get home from work tonight)

I assume that you have your page size set to 25 anyway you could do this caluclation to figure out what your iIndex should be:

Dim iPage, iValue

iPage = CInt(rsMiembro.AbsolutePage)
iValue = (iPage * 25) - 24
iIndex = iValue

So if iPage is 1 iValue will be one, if iPage is 2 i value will be 26 so on and so forth.

hth.

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature