Question re Recordset Navigation

[Jeremy Williams]

Does anyone know whether there is a Recordset Navigation extention that allows
you to display all of the pages or records at once with a "view all at once"
link or "all" link? I am using ASP VBScript and a Microsoft Access database.

Thank you in advance for any pointers!

[redtail01]

Any link can be used to an asp page that returns the content of an un filtered
recordset , or to save creating a new page use an else if statemnet with two
sql queries in the same page, if I understood your question correctly

[Tom Muck]

"Jeremy Williams" <webforumsuser@macromedia.com> wrote in message
news:d8n69m$flj$1@forums.macromedia.com...

> Does anyone know whether there is a Recordset Navigation extention that

allows

> you to display all of the pages or records at once with a "view all at

once"

> link or "all" link? I am using ASP VBScript and a Microsoft Access

database.

>
> Thank you in advance for any pointers!

Put this bit of code after the DW asp code above the HTML tag (use your
recordset name instead of Recordset1):

<%
tfm_showall = MM_urlStr
If Request("offset").Count > 0 AND CStr(Request("offset")) = "" Then
Repeat1__numRows = -1
Recordset1_last = Recordset1_total
End If
%>

Then create the link to show all records like this:

<a href="<%=tfm_showall%>">All</a>

Hope that helps.


--
Tom Muck
co-author Dreamweaver MX 2004: The Complete Reference
[url]http://www.tom-muck.com/[/url]

Extending Knowledge Daily
[url]http://www.communitymx.com/[/url]

[Jeremy Williams]

Tom,

Thank you for your reply. Does your "Horizontal Looper" script have this
record set navigation option to show "all" record sets? I am a recent convert
to Dreamweaver from Adobe GoLive and am still on the learning curve with
delving into ASP code. I have a lot of great reference books! Thank you,
again.