FrontPage/Access Help

[Bruce]

Hello,

I am using FrontPage 2000 and Access 2000 to create my website. The
site is a three page templated site that provides information about my
CD collection.

Page 1 is the Artist Page and lists the various performers. That page
is at http://www.winter-sky.com/ARTIST.PAGE.001.ASP. Clicking on an
artist brings you to Page 2.

Page 2 is the CD Page and it lists all the CDs that I have for a
particular artist. Clicking on a CD brings you to Page 3.

Page 3 is the Detail page and it lists the songs that are contained on
the CD that you clicked on on page 2.

My question is this: I would like allow visitors to the site who are
on page 3 to be able to go to the Detail page for the next CD w/out
having to go back to Page 2.

I know how to do this with a text site but not with one that is
created from a database as this one is.

If anyone can provide help or insights, I would be very appreciative.

Best,

Bruce Eisen

 

[Jim Buyens]

-----Original Message-----

Hello,
Howdy.

I am using FrontPage 2000 and Access 2000 to create my
website. The site is a three page templated site that
provides information about my CD collection.

Page 1 is the Artist Page and lists the various
performers. That page is at
http://www.winter-sky.com/ARTIST.PAGE.001.ASP. Clicking
on an artist brings you to Page 2.

Page 2 is the CD Page and it lists all the CDs that I
have for a particular artist. Clicking on a CD brings
you to Page 3.

Page 3 is the Detail page and it lists the songs that are
contained on the CD that you clicked on on page 2.

My question is this: I would like allow visitors to the
site who are on page 3 to be able to go to the Detail
page for the next CD w/out having to go back to Page 2.

I know how to do this with a text site but not with one
that is created from a database as this one is.

If anyone can provide help or insights, I would be very
appreciative.
Best,
Bruce Eisen

This is tricky to answer without knowing what you mean
by "next CD" and without knowing the structure of your
database.

In general, though, you need to Create a hyperlink with a
URL like
http://www.winter-sky.com/Song.Page.asp?
ConnectionValue=22&
DiscTitle=You+Can+All+Join+In&DiscID=25&ArtistID=7
(all one line) plus 1. You can access the current values
of each setting by means of expressions like
<%=request("ArtistId")%>

So, the code for the URL look like:
<a href="Song.Page.asp?
ConnectionValue=<%=Request("ConnectionValue")%>&
DiscTitle=<%=Server.UrlEncode(Request("DiskTitle"))%>&
DiscID=<%=Request("DiscID")%>&
ArtistID=<%=Request("ArtistID")%>">Next</a>
again, all on one line. However, if the low order field in
your Next order is Disc Title, code:
DiscTitle=<%=Server.UrlEncode(Request("DiskTitle"))
& "a"%>
If the low order field in numeric, such as DiscID or
Artist ID, code something like:
DiscID=<%=Request("DiscID") + 1%>

Next, modify the DRW region on the Song.asp page to search
for all hits >= the one on display, then only display the
first one.

If your order is ArtistID, DiscID, this would require a
SQL statement such as

SELECT * FROM TRACKS
WHERE (ArtistID = ::ArtistID: AND (DiscId >= :iscId:
OR (ArtistID > ::ArtistID:
ORDER BY ArtistID, DiscId

I must tell you, this is at the absolute limit of what you
can do with the Database Results Wizard. It's a real
candidate for writing your own ASP or ASP.NET code.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Bruce]

Jim,

Many thanks for your help, greatly appreciated.

Best,

Bruce