Adding Query Data 2
We use the same technique to retrieve the remaining values from the result set: CategoryName, Length, and Rating. Note that we place all of the data in a single table cell, that is, between a single pair of <td></td> tags. We also surround the text labels for our data elements with <b></b> tags to improve their visibility on the page.
Here is the HTML:
—TopPicks.csp—
TopPicks.csp
<html> <body>
<h2><font color="#0000FF">Today's Top Picks</font></h2>
<table border=0>
<csp:query name="FilmList" classname="Cinema.Film" queryname="TopFilms">
<tr>
<td>
<b>#(FilmList.Get("Title"))#</b><br>
#(FilmList.Get("Description"))#<br>
<b>Genre</b>
#(FilmList.Get("CategoryName"))#
<b>Length</b>
#(FilmList.Get("Length"))#
<b>Rating</b>
#(FilmList.Get("Rating"))#<br> <br>
</td>
<td></td>
</tr>
</table>
</body></html>