469,927 Members | 1,777 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,927 developers. It's quick & easy.

paging


What are different ways of provding PAGING THRU
RECORDSETS, I am working on search engine website.

thanks

Gary
Jul 19 '05 #1
3 1911
> What are different ways of provding PAGING THRU
RECORDSETS, I am working on search engine website.


http://www.aspfaq.com/2120
Jul 19 '05 #2
And here's a concept behind a different way of paging:

What's after TOP? by graz - 8/31/2000
http://www.sqlteam.com/item.asp?ItemID=566

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 19 '05 #3
"Bullschmidt" wrote:

And here's a concept behind a different way of paging:

What's after TOP? by graz - 8/31/2000
http://www.sqlteam.com/item.asp?ItemID=566


That seems even more elegant than the set subtraction technique allowed in
Oracle:

SELECT {fields} FROM {table} WHERE {primary key} IN
( SELECT {primary key} FROM {table or index table}
WHERE {condition} AND rownum < {upper bound}
MINUS
SELECT {primary key} FROM {table or index table}
WHERE {condition} AND rownum < {lower bound}
)

I wonder which is more efficient.
--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Guoqi Zheng | last post: by
6 posts views Thread by Shawn | last post: by
2 posts views Thread by asad | last post: by
2 posts views Thread by rn5a | last post: by
5 posts views Thread by Donald Adams | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.