<!--- Get list of Actors from database --->
<CFQUERY NAME="GetActors" DATASOURCE="ows">
  SELECT * FROM Actors
  ORDER BY NameFirst, NameLast
</CFQUERY>


<HTML>
<HEAD><TITLE>Orange Whip Studios Actors Stable</TITLE></HEAD>
<BODY>
<H2>Orange Whip Studios Actors Stable</H2>


<!--- Data entry form --->
<CFFORM ACTION="#CGI.SCRIPT_NAME#" METHOD="Post">

  <!--- Grid control for expenses --->
  <CFGRID 
    NAME="ActorGrid" 
    QUERY="GetActors"
    WIDTH="295"
    HEIGHT="300"
    ROWHEADERS="No"
    COLHEADERBOLD="Yes"
    COLHEADERALIGN="CENTER"
    SELECTMODE="ROW">
    <!--- Hidden column for ActorID - does not actually get displayed --->
    <CFGRIDCOLUMN 
      NAME="ActorID"
      DISPLAY="No">
    <!--- Column for actor's first name --->
    <CFGRIDCOLUMN 
      NAME="NameFirst"
      HEADER="First Name"
      WIDTH="100">
    <!--- Column for actor's last name --->
    <CFGRIDCOLUMN 
      NAME="NameLast"
      HEADER="Last Name"
      WIDTH="120"
      BOLD="Yes">
    <!--- Column for actor's age--->
    <CFGRIDCOLUMN 
      NAME="Age"
      HEADER="Age"
      DATAALIGN="Center"
      WIDTH="50"
      NUMBERFORMAT="999.">
  </CFGRID>

  <P><INPUT TYPE="Submit" VALUE="Submit Changes">
</CFFORM>

</BODY>
</HTML>