<!---
Name:        form.cfm
Author:      David Golden (d_golden73@hotmail.com)
Description: form page
Created:     5/01/01
--->

<cfinclude template="Connections/connOWS.cfm">
<cfquery name="GetFilmTitles" datasource=#MM_connOWS_DSN# username=#MM_connOWS_USERNAME# password=#MM_connOWS_PASSWORD#>
SELECT FilmID, MovieTitle FROM Films
</cfquery>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<form name="form2" method="post" action="results.cfm">
  <table width="55%" border="1" cellspacing="2" cellpadding="2">
    <tr> 
      <td colspan="2"><b>Current Expenses by Film</b></td>
    </tr>
    <tr> 
      <td width="41%" height="45">Select Film</td>
      <td width="59%" height="45"> 
        <select name="FilmSelection">
          <cfloop query="GetFilmTitles">
            <option value="<cfoutput>#GetFilmTitles.FilmID#</cfoutput>" ><cfoutput>#GetFilmTitles.MovieTitle#</cfoutput></option>
          </cfloop>
        </select>
      </td>
    </tr>
    <tr> 
      <td colspan="2" height="51"> 
        <input type="submit" name="Submit" value="Submit">
      </td>
    </tr>
  </table>
</form>
</body>
</html>

