title: how to count the sum of the list of products prices ( ColdFusion )
body: <p>here is the query:</p>
  
  <pre><code>&lt;cfquery name="GET_SHIP_ROW" datasource="#DSN2#"&gt;
      SELECT
          SR.*,
          S.STOCK_CODE
      FROM
          SHIP_ROW SR,
          #dsn3_alias#.STOCKS S
      WHERE
          SR.STOCK_ID = S.STOCK_ID AND 
          SR.SHIP_ID = #attributes.ship_id#
      ORDER BY
          SR.SHIP_ROW_ID
  &lt;/cfquery&gt;
  </code></pre>
  
  <p>for example i have a loop code of the prices:</p>
  
  <pre><code>  &lt;cfloop from="#satir_start#" to="#satir_end#" index="i"&gt;
      &lt;cfif i lte get_ship_row.recordcount&gt;
          &lt;cfscript&gt;
              if(len(get_ship_row.discount[i]))indirim = get_ship_row.discount[i]; else indirim = 0;
              adim_1 = get_ship_row.amount[i] * get_ship_row.price[i];
              adim_2 = (adim_1/100)*(100-indirim);
              adim_3 = adim_2*(get_ship_row.tax[i]/100);
              adim_4 = adim_2+adim_3;
          &lt;/cfscript&gt;
          &lt;cfquery name="GET_BARCODE" datasource="#DSN3#"&gt;
              SELECT
                  BARCOD
              FROM
                  PRODUCT
              WHERE 
                  PRODUCT_ID = #get_ship_row.product_id[i]#
          &lt;/cfquery&gt;
              &lt;table&gt;
            &lt;tr&gt;
              &lt;td style="width:30mm;"&gt;&lt;cfoutput&gt;#get_ship_row.stock_code[i]#&lt;/cfoutput&gt;&lt;/td&gt;
          &lt;td style="width:50mm;"&gt;&lt;cfoutput&gt;#left(get_ship_row.name_product[i],53)#&lt;/cfoutput&gt;&lt;/td&gt;
          &lt;td style="width:25mm;" align="right"&gt;&lt;cfoutput&gt;#get_ship_row.amount[i]# #get_ship_row.unit[i]#&lt;/cfoutput&gt;&lt;/td&gt;
          &lt;td style="width:25mm;" align="right"&gt;&lt;cfoutput&gt;#TLFormat(get_ship_row.price[i])#&lt;/cfoutput&gt; TL&lt;/td&gt;
          &lt;td style="width:35mm;" align="right"&gt;&lt;cfoutput&gt;#TLFormat(get_ship_row.amount[i] * get_ship_row.price[i])#&lt;/cfoutput&gt; TL&lt;/td&gt;
        &lt;/tr&gt;
      &lt;/table&gt;    
      &lt;/cfif&gt;
    &lt;/cfloop&gt;
  </code></pre>
  
  <p>there are displayed a list of the names and its prices, all i want to count, is their sum of prices, i mean of all the products. how do i dow it? thx for help!</p>