how do u retrieve data from a database ? i.e. i want to
retrieve 2nd record only from a database ? write code for
this. by using ADODB connecton, RSOBJ and using a FOR loop
we can retrieve all the records( ex: if we give query as
select * from emp). but i want only 2nd record. so how to
acheive this.

Answer Posted / cheryl

I think you need to set your for loop so that it reads only
2 records or as many records from the record set that you
want. i.e for i = 1 to 2

read the next record
next

this way you have the 2nd record

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What r the different filters in defect in quality center

3285


How do you do batch testing in wr and is it possible to do in qtp, if so explain?

507


How to change the priorities of the recovery scenario properties?

595


How to record application running on the Virtual machine?

644


If u r using library files (Instead of Check Points) , How do u do bitmap check ?

1455






How do we analyze the checkpoint results?

585


How may types of defects identify application or your currently working application?pls give me answer..

1517


i am looking job in perfomance testing using Loadrunner any one help me a project plz......?(Chandana) chs_29@rediffmail.com

1466


hai, i completed my b.tech in 2010 with 62.3%. i having knowledge on manual testing and Qtp. i want Relavent experience in testing.watever may be d salary i dont bother..I just want to gain knowledge. i dont have good communication skills.

1426


How to upload excel files into Quality Center using QTP Script and how to delete excel files from Quality?

614


How do you check ticket cost and ticket number in flight application?

591


Can any one brief some detail on how the shared and action object repository utilized/implemented in a real time project. I already know how to make shared object repositor by saving OR as .tsr extension..I wanted the actual concept of implementation...couple of live examples will be highly appreciated. Thanks

1899


What is method name to compare two XML files.

1537


i have doubt suppose iam purly working in QTP, when i will work on sql and performence testing? pls any one clarify doubt?

1504


What are benefits of qtp?

583