<!--- Query the database to get a listing of actors to chose from --->
<CFQUERY DATASOURCE="OWS" NAME="Actors">
SELECT NameFirst, NameLast, ActorId FROM Actors
      ORDER BY NameLast, NameFirst
</CFQUERY>

<HTML>

<HEAD>
<TITLE>Maintain Actor Photos</TITLE>
</HEAD>

<BODY BGCOLOR="#FFFFFF"> 

<H1>Maintain Actor Photos</H1>
<HR>
<H3>Click on Actor Name to Add Photo</H3>
<TABLE BORDER>
<TR>
<TH>Name</TH>
<TH>ID</TH>
</TR>
<CFOUTPUT QUERY="Actors">
<TR>
<TD><A HREF="actorphoto2.cfm?ActorID=#ActorID#">
<CFIF Len(Trim(NameLast))>#NameLast#, </CFIF>#NameFirst#</A></TD>
<TD>#NumberFormat(ActorId,'0000')#</TD>
</TR>
</CFOUTPUT>
</TABLE>
</BODY>
</HTML>
