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

In the Hybrid framework, data can access the database, excel file, XML etc. Is it true?

561


What is the limitation to XML Checkpoints?

1599


What is file database?

1688


What is ObjectParamater?

1569


Call to copy of an action and call to existing action… i know the diff but in real project how to use..? i want live scenario.pls help me..

1279






How do you create new test sets in td?

529


What is optional step in qtp? How you can add optional step in qtp?

526


To which environments does quicktest professional supports?

533


What is clean sweep?

1374


How to get popup error message.

1025


How do we handle run-time errors?

575


what are the utilities and drivers

1838


What processes will be required to manage updates to the web site's content, and what are the requirements for maintaining, tracking, and controlling page content, graphics, links, etc.?

601


how to find that tools work well with your existing system?

1401


Where we can use the analog mode and where we can use the low – level mode?

564