Just to add a comment to what everyone else has said - I've always seen
different syntax on this.
select SUM(Number) "NUMBER"
from Tbl_Numbers
May be an Oraclism or just local teaching. I'm not that well versed in the
differences between MSSQL and Oracle SQL.
Brian
-----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