Re: sql query to display search engine paging results

Hi,
I would be very interested in any answers you get to this post. Check out my post below (about 17 items down) from barryday. Sounds like I have the exact same problem that you have. If you get any good feedback, please forward them on and I'll do the same for you. Thanks. bday_at_autoprof.com

In article <942alf$9qp$1_at_nnrp1.deja.com>,   robert_b_allen_at_my-deja.com wrote:
> Hi,
>
> We are having a problem finding the right query to return the next
> resultset of say 75 when querying on last, first, and middle names.
> There are say 300 people with lastname like 'ALLEN%' and we want to
> show 75 records per page. Rownum doesn't group them by
> lastname,firstname so that doesn't work. Also if we know the 75'th
> record is say John M. Allen and we do a > , then it will not return
> Amanda Allen-Smith becuase Allen-Smith is like 'ALLEN%' but Amanda is
 <
> John. Do you understand my problem. We could build temporary views
> but that would require a lot of work and a lot of memory. Is there
 any
> way to do this with Oracle8 not 8i?
>
> Thanks for your help.
>
> Sent via Deja.com
> http://www.deja.com/
>

Sent via Deja.com
http://www.deja.com/ Received on Tue Jan 16 2001 - 15:13:33 CST