You have to select it as something, for example:
select sum(number) as sum_number
from Tbl_Numbers
Regards,
Lisa Haas
The Kennedy Center
-----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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
