Re: Paging -- need help with "next 10 results" implementation

It depends on your coding solution.  If you use an servlet or
application server, you can easily restrict the rows that are presented
and offer page up/down features.  For example, we use ColdFusion and the
looping mechanism itself provides the attributes startrecord and
maxrecords


-----Original Message-----
From: Bronwyn Hill [mailto:[email protected]] 
Sent: Thursday, January 16, 2003 3:08 AM
To: Oracle
Subject: [oracle] Re: Paging -- need help with "next 10 results"
implementation

Hi Adam, 

Did you ever find a solution to this ? I have not been able to find any 
solution to this problem .... I really need your help if you ever found 
any info ... I Have exactly the same problem 

Thanks a stack 
Bronwyn 

> Hi,
> I'm looking for guidance on how to implement paging using Oracle, and
> haven't found anything.
> 
> Specifically, I'm referring to the presentation of data to a user a 
little
> at a time, that is, in "pages".
> This is quite common on internet search engines, where a user might
> successfully match 5000 rows of data, but want to view only 20 rows at
a
> time.  It would be quite inefficient for the database server to return

all
> 5000 rows on each user request, and let the app server choose and
return
> the 20 rows that the user wants to see.  Yet this approach is what I
> see my fellow developers using.  
> 
> I've seen at least two approaches to paging for SQLServer, both using 
temp
> tables, which are trivial to create in SQLServer.
> 
> I've yet to see even a single article on how to implement this Oracle.
> 
> I imagine that at least one of the big search engines uses Oracle on
the
> back end.
> How do they implement paging?  Can anyone give me an authoritative
answer
> on this?  It would be greatly appreciated.
> 
> Thanks,
> Adam
---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to %%email.unsub%%.

---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].