Gossamer Forum: Products: Gossamer Forum: Discussion: Re: [SeanP] Total of a Field... (Andy)

Gossamer Threads

Home : Products : Gossamer Forum : Discussion :

Re: [SeanP] Total of a Field...

Nov 30, 2004, 8:26 AM

Andy

Veteran / Moderator (18441 posts)

Nov 30, 2004, 8:26 AM

Shortcut

Re: [SeanP] Total of a Field... In reply to

For every user?

You could try;

<%global_name%>

Code:
sub { 
   my $total; 
   my $sth = $DB->table('User')->select( ['FieldName'] ); 
   while (my ($value) = $sth->fetchrow) { 
      $total += $value; 
   } 
   return $total; 
}

This is untested, and will require a little tweaking to match up with your field names ... but it should work :)

Cheers

Andy (mod)
andy@ultranerds.co.uk

Subject	Author	Views	Date
Total of a Field...	SeanP	2811	Nov 30, 2004, 8:14 AM

Re: [SeanP] Total of a Field...	Andy	2717	Nov 30, 2004, 8:26 AM

Re: [Andy] Total of a Field...	SeanP	2705	Nov 30, 2004, 8:54 AM

Gossamer Threads is a Vancouver-based company with over 28 years experience in web technology. From development to hosting, we partner with leading organizations around the globe and help to build their web presences, strategies and infrastructures.

Let’s talk: 1-877-715-7676