| 10.0 |
The Detail Page.
|
| 10.1 |
First we need to create
a final Query in Access, open access and double click on Create
Query in Design View (refer back to section 8.3 if necessary).
Add the following tables:
Albums
AlbumFormats
Formats
Genres
|
| 10.2 |
Double click the following
:
AlbumID, ArtistName and AlbumTitle in the Albums Table.
Genre in the Genres Table.
Format in the Formats Table.
The columns at the lower half of the Query Designer window should
now appear as follows:
Close the Query Designer window and save the Query as QryDetails.
|
| 10.3 |
In Ultradev open the details.asp
page.
In the Data Bindings, click on the plus button and select Recordset
(Query) from the drop down menu (refer back to section 7.2 if
necessary).
If the Recordset options palette is in Advanced view, click
on the Simple button to return to simple view.
Name the recordset rsQryDetails,
select TDSFdemoOLE from
the connection drop down list and QryDetails
from the Table drop down list, leave columns as All.
In the Filter drop down list select AlbumID,
make sure the next three items selected are =,
URL Parameter
and AlbumID.
|
| 10.4 |
Click test then OK on the
Test Value dialogue box.
You should see the details for AlbumID 1, four rows , 1 for
each format that the album is available on.
Click OK to close the Test SQL Statement window, then OK on
the Recordset options palette to close that as well.
|
| 10.5 |
Click the plus button in
the Data Bindings window to add another Recordset.
Name the Recordset rsTblTracks,
select the TDSFdemoOLE
connection and select TrackListings
from Table drop down list. Select AlbumID
from the Filter drop down and ensure the next three items are
=, URL
Parameter and AlbumID.
|
| 10.6 |
Click Test, and OK in the
Test Value dialogue box, you should see the list of track numbers
and tracks for AlbumID 1. |
| 10.7 |
As we did in section 8.27, click on the plus symbol next
to the recordsets to expand the view and show the available
fields.
Drag the fields to the page and placing them in the relevant
table cells as follows:
|
| 10.8 |
Next Click on the Table
within the cell to the right of Available Formats to select
it.
With the table still selected use the repeat region server behaviour
as we did back in section 8.33. Ensure that rsQryDetails
is selected in the drop down box and select the All
Records option.
|
| 10.9 |
Now select the Table to
the right of Tracks.
And use the Repeat Region Server behaviour again, this time
selecting rsTblTracks
in the drop down box and again select the All
Records option.
The finished details page should now look like this:
Save the page and close it, our search pages are now finished.
Select search.asp in the
Site window and press F12 to preview the site in your default
browser. Your search pages should now function in exactly the
same manner as the original pages. |
