Wouldn't that be:
<cfquery datasource=#variable.ds# name="get_sum">
select sum(number) as whatever from Tbl_Numbers
</cfquery>
and then
<cfoutput>#get_sum.whatever#</cfoutput>
?
----- Original Message -----
From: "Kevin Queen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 03, 2001 3:36 PM
Subject: SQL SUM Question
> List,
> If I run the following query:
>
> Select Number from Tbl_Numbers SUM(Number)
>
> how can I oputput the SUMed variable in a cfoutput?
>
> TIA,
> Kevin Queen
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
