kravindra
asked on
How to read records from recordset in asp
i have 3 records in the table.using recordset i am fetching the data.how to retrive 2nd second record from the table using recordset.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Originally closed by accepting http:#a25299659 with a B grade.
ChetOS82: Answers with a MoveNext (This will not give the results that are needed)
poweraddict: Answers with code that give "ALL" the records in the requested Table. (This also will not give the results that are needed)
DarkHill: Does the same thing as "poweradict" (As the above, will not give the results that are asked for)
Carrzkiss: Does a MoveLast (This will give the results that are asked for)
---------
OK.
A Split = Reason it is not a good idea.
Someone comes in that does not read the entire post is going to start with the 1st answer on the page, they are not going to get the results that they asked for, and then they will move the the next, and IF they do not read the information at the bottom they are going to give up and are not going to be satisfied with the information that they have received from their money they have paid in to EE for their membership.
The ONLY answer that is real in this Thread is: http:#a25301023
It give the results that are asked for, and does it in a simple easy to understand code.
If you accept everyone as Answer, than this is defeating the purpose of what EE is and what the people pay to receive. Which is Answers, not code that does not work.
I mean no offence to anyone that has tried to assist in this Thread, but I do not feel that a split is appropriate and it is absolutely not the right thing to do.
Reason: How can you split with 3 wrong answers and 1 right answer? You cannot!
Proposed Only Answer: http:#a25301023 = Grade "A"
Have a good one.
Carrzkiss
poweraddict: Answers with code that give "ALL" the records in the requested Table. (This also will not give the results that are needed)
DarkHill: Does the same thing as "poweradict" (As the above, will not give the results that are asked for)
Carrzkiss: Does a MoveLast (This will give the results that are asked for)
---------
OK.
A Split = Reason it is not a good idea.
Someone comes in that does not read the entire post is going to start with the 1st answer on the page, they are not going to get the results that they asked for, and then they will move the the next, and IF they do not read the information at the bottom they are going to give up and are not going to be satisfied with the information that they have received from their money they have paid in to EE for their membership.
The ONLY answer that is real in this Thread is: http:#a25301023
It give the results that are asked for, and does it in a simple easy to understand code.
If you accept everyone as Answer, than this is defeating the purpose of what EE is and what the people pay to receive. Which is Answers, not code that does not work.
I mean no offence to anyone that has tried to assist in this Thread, but I do not feel that a split is appropriate and it is absolutely not the right thing to do.
Reason: How can you split with 3 wrong answers and 1 right answer? You cannot!
Proposed Only Answer: http:#a25301023 = Grade "A"
Have a good one.
Carrzkiss
All of my post did not get posted for some reason. This is the rest.
--------------------------
The asker: kravindra
Asked the following question:
==========================
i have 3 records in the table.using recordset i am fetching the data.how to retrive 2nd second record from the table using recordset.
==========================
This question is simple and easy to understand. (Why the asker accepted what he/she did is beyond me)
They are wanting the "2nd Record" in the database.
--------------Now read my previos post--------------- http:#a25430096
Carrzkiss
--------------------------
The asker: kravindra
Asked the following question:
==========================
i have 3 records in the table.using recordset i am fetching the data.how to retrive 2nd second record from the table using recordset.
==========================
This question is simple and easy to understand. (Why the asker accepted what he/she did is beyond me)
They are wanting the "2nd Record" in the database.
--------------Now read my previos post--------------- http:#a25430096
Carrzkiss
ASKER
it's working fine.
Do not really agree with the conclusion.
At least it is finalized.
Carrzkiss
At least it is finalized.
Carrzkiss
poweraddict's code DOES NOT give you the 2nd record, it gives you all the records within the table.
The code that I provided for you gives you the 2nd record in the table, of which is what you ask for.
This is totally uncool.
Carrzkiss