Solved

ADO get current record position

Posted on 2004-03-26
4
405 Views
Last Modified: 2008-02-01
i 'm able to write
adodb.recordset.absoluteposition...

how do i read the current position of record without using variable?
0
Comment
Question by:ill
  • 2
  • 2
4 Comments
 
LVL 11

Expert Comment

by:Slimshaneey
ID: 10685524
Please elaborate???

You can just write to the asp page by
response.write recordsetname.absoluteposition
0
 
LVL 12

Author Comment

by:ill
ID: 10685725
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
0
 
LVL 11

Accepted Solution

by:
Slimshaneey earned 50 total points
ID: 10685740
Ah...
Stick this line in before the opening of the recordset:
db.Cursorlocation = 3
0
 
LVL 12

Author Comment

by:ill
ID: 10685840
uff, so that's it...
thanks
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now