Sometimes you just have to show off what you have. Most often, for us computer folks, all we really have is database tables filled with raw data. Fortunately though, Data Bridge makes it easy to flaunt that data to the world with the beauty known as Repeating Tables.
In this tutorial, we're going cover the basic process of applying Repeating Tables to a page, so we can let everyone see just how great our data is.
We will be using the WebAssist classic Blue Sky Music database for this tutorial, but if you happen to have existing databases ready for use, feel free to plug in your database information in the place of the Blue Sky Music information.
For those of you that don't have immediate access to a database filled with data, we're going to use the Blue Sky Music database. This will give us tables filled with data that can easily be used for Repeating Tables.
Now that we have the database, we're going to need a page with a recordset on it to pull the data from the database to display. For this example we're using the items demo data that's populated with several albums and their details.
Now we're pulling all the data from the items table in the database.
We need to add some basic styles to the page to help you see how Repeating Tables is working once we have it up and running. These will add different background colors to the even and odd rows once the data is being displayed.
Now we can tell which rows are which.
Now that you have the records your Repeating Tables business is going to be pulling its information from, and the styles to make your page beautiful, you're going to need to actually apply the Repeating Tables Server Behavior to your page.
You can now see the Repeated Table added to the page with the text "Your Repeated Content". It only looks like one table cell, but it will be repeated for each element in the database.
Our last step is to add the content we want shown to the repeated table cell in the form of a recordset binding.
Voil?! You've now created a table that repeats as many cell as needed to display all the entries in your recordset binding. You should preview the page and make sure everything worked, then bask in your own glory. You've earned it.
I've been watching you, and I see that you're getting pretty darn good at this web development stuff. You should sharpen your skills even more. Maybe add additional styling to the displayed rows, or add a nice header to your table. The sky is the limit now that you know Repeating Tables! ... Well, the sky being anything related to Repeating Tables, but you catch my drift.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.