By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,077 Members | 2,121 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,077 IT Pros & Developers. It's quick & easy.

recordset paging

P: n/a
Hi all,
I have a strange problem. I have a page where I am
creating a recordset that can handle paging and the query
for it was originally selecting from only one table. This
was all working nicely, including the paging. I have now
changed the query to select from two joined tables and
suddenly it tells me that my recordset does not support
paging. Why is this?

Any help would be much appreciated,
Thanks,
Sara
Jul 22 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
sara wrote:
Hi all,
I have a strange problem. I have a page where I am
creating a recordset that can handle paging and the query
for it was originally selecting from only one table. This
was all working nicely, including the paging. I have now
changed the query to select from two joined tables and
suddenly it tells me that my recordset does not support
paging. Why is this?


Without seeing the code used to open the recordset, or the query used to
retrieve the records, we can only guess.

My guess is that you are opening a server-side cursor. You should set the
CursorLocation (look it up at msdn.microsoft.com/library) to adUseClient,
which will allow you to retrieve a static cursor that supports paging.

There are more efficient paging strategies described at:
http://www.aspfaq.com/show.asp?id=2120

HTH,
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 22 '05 #2

P: n/a
I agree

"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:OX**************@TK2MSFTNGP12.phx.gbl...
sara wrote:
Hi all,
I have a strange problem. I have a page where I am
creating a recordset that can handle paging and the query
for it was originally selecting from only one table. This
was all working nicely, including the paging. I have now
changed the query to select from two joined tables and
suddenly it tells me that my recordset does not support
paging. Why is this?


Without seeing the code used to open the recordset, or the query used to
retrieve the records, we can only guess.

My guess is that you are opening a server-side cursor. You should set the
CursorLocation (look it up at msdn.microsoft.com/library) to adUseClient,
which will allow you to retrieve a static cursor that supports paging.

There are more efficient paging strategies described at:
http://www.aspfaq.com/show.asp?id=2120

HTH,
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Jul 22 '05 #3

P: n/a
er, thanks.

Adam Short wrote:
I agree

"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:OX**************@TK2MSFTNGP12.phx.gbl...
sara wrote:
Hi all,
I have a strange problem. I have a page where I am
creating a recordset that can handle paging and the query
for it was originally selecting from only one table. This
was all working nicely, including the paging. I have now
changed the query to select from two joined tables and
suddenly it tells me that my recordset does not support
paging. Why is this?


Without seeing the code used to open the recordset, or the query
used to retrieve the records, we can only guess.

My guess is that you are opening a server-side cursor. You should
set the CursorLocation (look it up at msdn.microsoft.com/library) to
adUseClient, which will allow you to retrieve a static cursor that
supports paging. There are more efficient paging strategies described at:
http://www.aspfaq.com/show.asp?id=2120

Jul 22 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.