Link to home
Start Free TrialLog in
Avatar of ill
illFlag for Slovakia

asked on

ADO get current record position

i 'm able to write
adodb.recordset.absoluteposition...

how do i read the current position of record without using variable?
Avatar of Slimshaneey
Slimshaneey
Flag of United Kingdom of Great Britain and Northern Ireland image

Please elaborate???

You can just write to the asp page by
response.write recordsetname.absoluteposition
Avatar of ill

ASKER

Set db = Server.CreateObject("ADODB.Connection")
db.Open (Session("mydb") )
Set rs = Server.CreateObject("ADODB.Recordset")
set rs= db.execute ( " select * from users")

do while not rs.eof
      response.write ( rs.absoluteposition&"<br>")   'returns -1 for all records
      rs.movenext
loop
ASKER CERTIFIED SOLUTION
Avatar of Slimshaneey
Slimshaneey
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ill

ASKER

uff, so that's it...
thanks