Professional Web Applications Themes

Adding Columns - Coldfusion - Getting Started

Hi, Is there a way to add up the values of each column in a table? Here's a snippet of code: <tr> <td><cfoutput>#FCEX9151# :<br></cfoutput></td> <td><cfoutput>#A#<br> </cfoutput></td> </tr> Algeria : 22 Canada: 16 Brazil: 20 Where each country above is #FCEX9151# and each number #A#. Is there a way to add up #A#, (i.e. 22+16+20) in CF? Thanks for your help! and it looks like:...

  1. #1

    Default Adding Columns

    Hi,

    Is there a way to add up the values of each column in a table?

    Here's a snippet of code:

    <tr>
    <td><cfoutput>#FCEX9151# :<br></cfoutput></td>
    <td><cfoutput>#A#<br> </cfoutput></td>
    </tr>

    Algeria : 22
    Canada: 16
    Brazil: 20

    Where each country above is #FCEX9151# and each number #A#. Is there a way
    to add up #A#, (i.e. 22+16+20) in CF?

    Thanks for your help!


    and it looks like:





    jenn Guest

  2. #2

    Default Re: Adding Columns

    Assuming you have done a database query and are looping over the results, the
    code below should get you started.

    <CFQUERY NAME="getCountry" ...>
    SELECT FCEX9151, A FROM myTable WHERE ...
    </CFQUERY>

    <CFSET counter = 0>
    <CFOUTPUT QUERY="getCountry">
    #FCEX9151# #A#<BR>
    <CFSET counter = counter + A>
    </CFOUTPUT>
    <CFOUTPUT>
    Total: #counter#
    </CFOUTPUT>

    jdeline Guest

  3. #3

    Default Re: Adding Columns

    If you have a query like this:

    select thefield, count(field) thecount
    from atable
    where whatever
    group by thefield

    A really geeky way to add up the thecount's is
    thesum = arraysum(theQuery["thecount"]);

    A less geeky, but equally effective method is to use query of queries.

    Dan Guest

Similar Threads

  1. adding columns to an existing recordset
    By rorajoey in forum Macromedia ColdFusion
    Replies: 2
    Last Post: April 22nd, 05:29 PM
  2. Adding Custom Columns to DataGrid
    By flexbay in forum Macromedia Flex General Discussion
    Replies: 2
    Last Post: March 7th, 04:49 PM
  3. Adding columns dynamically
    By Peter Kamitz in forum ASP.NET Data Grid Control
    Replies: 2
    Last Post: March 2nd, 06:11 PM
  4. Adding Columns to Datagrid Dynamically
    By Sal in forum ASP.NET Data Grid Control
    Replies: 1
    Last Post: February 28th, 09:32 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139