Skip to main content
Anonymous
August 16, 2008
Answered

ASP Recordset paging problem

  • August 16, 2008
  • 2 replies
  • 379 views
Greetings, I am working on the development of several ASP pages which involve potentially large recordsets. It has been a few years since I last did this, but the problem I am experiencing is this; the query to the database (SQL Server) works fine, the recordset is displayed as expected, but only to the extent that I only want to allow a max of 25 records at a time to be retrieved. I have included the recordset paging option from DW CS3 with a Display if condition, again no problem there. However, when the first 25 records are returned, and the Next button is clicked, the next 25 records are not being displayed. It's as if the recordset is empty now.

I have checked my books for DW MX2004, and the method appears the same, but the problem persists. Since this tends to be a server side behaviour, is there something that needs to be set on the server for this to function? Any help is appreciated!
This topic is closed to new replies. Start a new post to keep the conversation going.
Correct answer
Steve, Thanks for your interest. I have found my problem (searched many other sources). Anyway, the problem ended up being that I was using POST rather than GET on my form and had passed a form variable rather than a URL variable. It all works now. I wish the Dreamweaver documentation was a little more clear on this point. Thank goodness for these kinds of forums!

2 replies

Newsgroup_User
Inspiring
August 17, 2008
Can you please post the URL so that we can see the code? Thanks

"BadDadRev1" <webforumsuser@macromedia.com> wrote in message
news:g86p18$aod$1@forums.macromedia.com...
> Greetings, I am working on the development of several ASP pages which
> involve
> potentially large recordsets. It has been a few years since I last did
> this,
> but the problem I am experiencing is this; the query to the database (SQL
> Server) works fine, the recordset is displayed as expected, but only to
> the
> extent that I only want to allow a max of 25 records at a time to be
> retrieved.
> I have included the recordset paging option from DW CS3 with a Display if
> condition, again no problem there. However, when the first 25 records are
> returned, and the Next button is clicked, the next 25 records are not
> being
> displayed. It's as if the recordset is empty now.
>
> I have checked my books for DW MX2004, and the method appears the same,
> but
> the problem persists. Since this tends to be a server side behaviour, is
> there
> something that needs to be set on the server for this to function? Any
> help is
> appreciated!
>


Anonymous
Correct answer
August 18, 2008
Steve, Thanks for your interest. I have found my problem (searched many other sources). Anyway, the problem ended up being that I was using POST rather than GET on my form and had passed a form variable rather than a URL variable. It all works now. I wish the Dreamweaver documentation was a little more clear on this point. Thank goodness for these kinds of forums!
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices