<!--- Get list of merchandise from database --->
<CFQUERY NAME="GetMerch" DATASOURCE="#REQUEST.DataSource#"
  CACHEDWITHIN="#CreateTimeSpan(0,1,0,0)#">
  SELECT MerchID, MerchPrice
  FROM Merchandise
  ORDER BY MerchName
</CFQUERY>

<!--- Show header images, etc., for Online Store --->
<CFINCLUDE TEMPLATE="StoreHeader.cfm">

<!--- Show merchandise in a HTML table --->
<P>
<TABLE>
  <TR>
    <!--- For each piece of merchandise --->
    <CFLOOP QUERY="GetMerch">
      <TD>
        <!--- Show this piece of merchandise --->
        <CF_MerchDisplay
          MerchID="#MerchID#">
      </TD>  
      
      <!--- Alternate left and right columns --->
      <CFIF CurrentRow MOD 2 EQ 0></TR><TR></CFIF>
    </CFLOOP>  
  </TR>
</TABLE>

</BODY>
</HTML>
