Hi,
I am having a problem with the AbsolutePosition method.
Here is the code:

function PositionOfMyAd(p_user)  
set rsTable = Server.CreateObject("ADODB.Recordset")
rsTable.Open "SELECT p_name, p_user FROM tblUsers ORDER BY p_rating DESC ", MM_conn_STRING, 1,3
while NOT rsTable.EOF

    Response.Write("user=" & rsTable("p_name") & "position=" &    rsTable.AbsolutePosition & "<br>")
rsTable.Movenext
wend
rsTable.Close 
set rsTable = Nothing
end function

I am getting "-1" values.
I have tried several cursor types but I am getting the same result.
Any ideas?

And another question
Maybe someone can suggest me with a way to find a position of a recordset in DB.
I have a list of users that are "rated" by 'p_rating" value and I would like to return a position of some spesific user in the DB sorted by "p_rating"

This is why I hate the default ASP samples provided...they're so useless.

Anyway, the first thing you should be doing is using a sub instead of a function. Functions are only meant to be used when you want to return a value back to your script. Subs are used to process blocks of code (which is what your sample is.)

Second, instead of using a while loop, use a for loop to iterate through your recordset.

for i = 1 to RS.RecordCount
 Response.Write("user=" & rsTable("p_name") & "position=" & i & "<br>")

Next

Since the i is a for loop counter, it will increase by one each time.

Hey!
Yeah, it's nice way do complete the task but i don't want to scroll through
the entire DB. ( not in the original task )

I need to find some position of a recordset in the DB. In your way I will have to pass through all the query to find the one I need.
I thought about using the .Find operation that will return me the position of the record.
Like:

rsTable.Open "SELECT p_name, p_user FROM tblUsers ORDER BY p_rating DESC ", MM_conn_STRING, 1,3
'rsTable.Find "p_user = '" & p_user & "'", 1, 1, 1 
Response.Write("user=" & rsTable("p_name") & "position=" & rsTable.AbsolutePosition & "<br>")

How can that be done?

AbsolutePosition does not tell you the position of a record in the table, it tells you the position in the recordset.

the CursorLocation must be adUseClient (3).

does the database type you are using support the property ?

You're going to have to iterate through it somehow to do this. Whether you do it using the recordset or you output the recordset to an array and do it that way, it still has to be compared in this manner.

There really isn't a better way to do it.