4 Replies Latest reply: Dec 8, 2010 5:51 PM by Andy Matthews RSS

    Simple Math in SQL Query or cfset

    sakonnetweb Community Member

      Calculated fields in the DB vs <cfset>?

       

      It would seem simple, but:

       

      ACCESS DB ;>(

      CF9

      IIS

       

      <cfquery name="get_total" datasource="#Request.BaseDSN#">
      SELECT SUM((current_charge+penalty)-credit) AS total
      FROM moorings
      WHERE mooring_ID = #URL.mooring_ID#
      </cfquery>

       

      <cfdump var="#total#"> 

       

      Variable TOTAL is undefined?

       

      or

       

      <cfset subtotal = current_charge+penalty>

       

      <cfset total = subtotal-credit>

       

      Variable CURRENT_CHARGE is undefined?

       

      Missing ',", (, #'s?

       

      Thanks