Try this it works for me
<CFQUERY NAME="Whatever" DATASOURCE="dsn">
SELECT SUM(columnName) AS Somesum
FROM tableName
</cfquery>
H Larry Juncker
L Senior Cold Fusion Programmer
I Heartland Communications Group
Internet Division
-----Original Message-----
From: Miriam Hirschman [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 22, 2000 3: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
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
