<!--- Execute the stored GetAllExpenses stored procedure --->
<CFSTOREDPROC 
  DATASOURCE="owsServer"
  PROCEDURE="GetAllExpenses">
  <!--- Capture the recordset returned by the procedure --->
  <!--- The recordset can be used just like a normal query --->
  <CFPROCRESULT NAME="GetExp">  
</CFSTOREDPROC>


<HTML>
<HEAD><TITLE>Film Expenses</TITLE></HEAD>
<BODY>
<H2>Expense Overview</H2>

<P><I>These values were returned by the GetAllExpenses stored procedure.</I><BR>

<!--- Output film-level expense summary --->
<CFTABLE 
  QUERY="GetExp" 
  HTMLTABLE="Yes" 
  BORDER="Yes" 
  COLHEADERS="Yes">
  <!--- For each expense, columns for film, description, date, and amount --->
  <CFCOL HEADER="Film Title" TEXT="#MovieTitle#">
  <CFCOL HEADER="Description" TEXT="#Description#">
  <CFCOL HEADER="Date" TEXT="#LSDateFormat(ExpenseDate)#">
  <CFCOL HEADER="Amount" TEXT="#LSCurrencyFormat(ExpenseAmount)#">
</CFTABLE>

</BODY>
</HTML>