|
 |
asp_databases thread: getting specific record from a query
Message #1 by "Vinod Lalchandani" <vinod_lalchandani@r...> on Tue, 19 Jun 2001 08:41:17
|
|
Hi,
I have a stored procedure which returns me a huge recordset.
My query is that can we get selected records from the recordset
through SQL.
For eg. I want 10 records starting from the 11th record
of the recordset. There is a keyword called as TOP which can
be used to fetch specific records starting from the TOP
but it is not of much help to me.
If anyone has the solution please send me as soon as possible.
Thanks and Regards,
Vinod
Message #2 by Gee Vee <happygv@y...> on Tue, 19 Jun 2001 02:01:41 -0700 (PDT)
|
|
Hi Vinod,
I too had the same kind of requirement and came across
this URL which help me a lot.
http://www.4guysfromrolla.com/webtech/062899-1.shtml
Really good stuff. A little modification to the
example given here will provide you more felxibility
in retrieving the selected set of records from the DB.
Check this out.
Have a nice time.
Regards
Vijay.G
Message #3 by prasadpatil_asp@1... on 19 Jun 2001 02:31:39 -0700
|
|
Hi,
ADO has support for paging. First you have to specify no of records per
page(recordset.PageSize).Then u can jump to any page by using
recordset.AbsolutePage.
In ur case first create recordset then specify pagesize as 10.then set
absolute page to 2 u will get record nos from 11 to 20.
Let me know is this soln worked or not.
Regards,
Prasad Patil(prasadpatil_asp@1...)
On Tue, 19 June 2001, "Vinod Lalchandani" wrote:
>
> Hi,
>
> I have a stored procedure which returns me a huge recordset.
> My query is that can we get selected records from the recordset
> through SQL.
> For eg. I want 10 records starting from the 11th record
> of the recordset. There is a keyword called as TOP which can
> be used to fetch specific records starting from the TOP
> but it is not of much help to me.
> If anyone has the solution please send me as soon as possible.
>
> Thanks and Regards,
>
> Vinod
|
|
|
View Cart
