home about/faq features tutorials resources members search

Using FTP Server Access for Site Development with UltraDev

by Judy Fontanella

Second ASP Page - see_sites.asp

  1. Open a new page and save it in your site folder as "see_sites.asp".
  2. To create the new recordset for this page, click on the "+" in the upper left corner of the the Data Bindings Panel and select Recordset (Query).

  1. The recordset dialog box should look like the one in the following picture. For this page, we want a list of sites. Name the recordset rsSites. For the connection, choose connLinks. Choose the Sites table. The fields in the Sites table will appear under Columns:. We will use all of the fields, so leave All selected.

    For this recordset, we don't want all of the records. We just want the sites that have the same topic as the one that our visitor chose. We will use a filter to select the right records. Next to Filter: select the SiteTopic column as the field that we will filter on. Choose the "=" sign, because we want the value of the field to equal the value of the URL Parameter. Choose URL Parameter as the object that we want to compare the SiteTopics field to. Finally, type in Topic, the name that we gave to the URL Parameter that is being passed from the previous page.

    It would be logical to arrange the site list alphabetically. Under Sort:, choose SiteName as the field to sort on, and leave the default, Ascending. You can click Test and then OK.

  1. Now we can put our list of sites on the page. There are many different arrangements you can use to display your data. I am using a table with 4 rows and 2 columns. You can drag your data source placeholders from the Data Bindings panel to the page and place them where you want them to go. Then you can select them and apply text formatting just as if they were ordinary text.

  1. The URL of each site will be a link to the actual site. Therefore, select the {rsSites.SiteURL} data source. Click on the browse for file icon on the Properties Panel. The Select File dialog box will appear. At the top it will say, "Select Name From:" and you can choose either File System or Data Sources. Choose Data Sources. From the list of Data Sources that appears, select SiteURL.

  1. The last thing we need to do is to apply a Repeat Region server behavior to the page so we see more than one site on our list. Select the entire table that holds the listing for the sites. Then click the "+" in the Server Behavior Panel and select Repeat Region. In the Repeat Region dialog box, select the rsSites recordset and All Records next to Show:. Note: The Repeat Region will work best if your table alignment is set to "center".

  1. Save your file and upload it to the server. Test it by first browsing to choose_topic.asp. Click on a topic link to see the list of sites on the see_sites.asp page.


  1. That's it. You've created an application for the Web!! Now, you can change the sites and the categories in the database to really customize your site. For ideas on how you might extend your new skills, you can visit the dynamic list of links for UltraDev that I created with UltraDev's help. It's at http://artbytes.net/UDlinks.

Copyright 2002, Judy Fontanella, All Rights Reserved

Photo of Judy Fontenella

Judy Fontanella owns her own Web design company called ArtBytes in San Diego, California. She also teaches both online and face-to-face Web design classes for Palomar Community College in San Marcos, California.

[an error occurred while processing this directive]


Learning Podcasting by Carolyn Wood.


Complete list of past tutorials.


Printable version of this page

Link to us

Join the discussion lists

passionate about the web