Gossamer Forum: Products: Gossamer Links: Development, Plugins and Globals: SELECT SUM()

Gossamer Threads

Home : Products : Gossamer Links : Development, Plugins and Globals :

Products: Gossamer Links: Development, Plugins and Globals: SELECT SUM() - help: Edit Log

Here is the list of edits for this post

Aug 20, 2004, 1:16 AM

ryel01

Veteran (1264 posts)

Aug 20, 2004, 1:16 AM

SELECT SUM() - help

hello!

I'm processing a loop of records and want to get the total sum of a particular column for all of the records.

I want the total to be allocated to $total_asked.

The column I'm after is "asked".

The following code isn't working for me... where it should return a total of 75 the result I'm getting is 556538336.

Code:
for each of my records... 

	my $cond = GT::SQL::Condition->new( 
		question_id_fk	=> '=' => "$_->{'question_id'}" 
	); 

	$total_asked += $db->select('SUM(asked)', $cond ); 

...

Can anyone help?

Thanks

r

edit: just corrected the code

Last edited by:

ryel01: Aug 20, 2004, 1:27 AM

Edit Log:

Post edited by ryel01 Post edited by ryel01 (Veteran) on Aug 20, 2004, 1:27 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