Have you tried doing it with SQL rather than CF? The database is generally
much faster than CF for stuff like this:
SELECT sum(column) as theSum
FROM table
Or perhaps:
SELECT column1+column2+column3 as theSum
FROM table
- Phil
philip j. kaplan : pk interactive nyc
: www.pkinteractive.com
: vox +1 212.273.9623
: fax +1 212.273.9642
-----Original Message-----
From: Miriam Hirschman [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 22, 2000 4:09 PM
To: CF Forum
Subject: Sum
Is there a way in CF that you can add the summ of all the results in a
certain query?
Thanks,
---miriam
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or send
a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
