^ pop-out codeShare ^
  1. <cfsilent>
  2.     <cfscript>
  3.         // loop through the query set and add up only non expired values for the total
  4.         variables.currentTotal = 0;
  5.         for (i=1;i LTE arrayLen(sqlQry['amount']); i=i+1)
  6.             {
  7.                 if (not len(sqlQry['expirationDate'][i]))
  8.                     {
  9.                         variables.currentTotal = variables.currentTotal + sqlQry['amount'][i];
  10.                     }
  11.             }
  12.     </cfscript>
  13. </cfsilent>