ASP Recordset paging problem

[Guest]

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!

[Newsgroup_User]

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!
>

[Guest · Accepted solution]

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!