select number sum(number)
from tbl_numbers
<cfoutput query>
#number#
I think that is right I would try it
> -----Original Message-----
> From: Kevin Queen [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 03, 2001 4:36 PM
> To: CF-Talk
> 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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
