<!---
Name:        movies.cfm
Author:      Ben Forta (ben@forta.com)
Description: Movie maintainance applciation
Created:     4/20/01
--->

<!--- Get all movies --->
<CFQUERY DATASOURCE="ows" NAME="movies">
SELECT FilmID, MovieTitle
FROM Films
ORDER BY MovieTitle
</CFQUERY>

<!--- Page header --->
<CFINCLUDE TEMPLATE="header.cfm">

<TABLE ALIGN="center" BGCOLOR="orange">

    <!--- Loop through movies --->
    <CFOUTPUT QUERY="movies">
        <TR>
            <!--- Movie name --->
            <TD><B>#MovieTitle#</B></TD>
            <!--- Edit link --->
            <TD><A HREF="edit3.cfm?FilmID=#FilmID#">[Edit]</A></TD>
            <!--- Delete link --->
            <TD><A HREF="delete2.cfm?FilmID=#FilmID#"">[Delete]</A></TD>
        </TR>
    </CFOUTPUT>

    <TR>
        <TD></TD>
        <!--- Add movie link --->
        <TD COLSPAN="2" ALIGN="center"><A HREF="edit3.cfm">[Add]</A></TD>
    </TR>

</TABLE>

<!--- Page footer --->
<CFINCLUDE TEMPLATE="footer.cfm">


