Re: SQL sum question

2007-05-18 Thread Gareth Hughes
I really should have been able to figure that out. Hopefully I'll remember next time :) Many thanks Jochem. - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, May 18, 2007 12:36 PM Subject: Re: SQL sum question Gareth

Re: SQL sum question

2007-05-18 Thread Jochem van Dieten
Gareth Hughes wrote: select pname,sum(pagehit) as pagehit where dates between x and y group by pname, pagehit order by pagehit desc, pname select pname,sum(pagehit) as pageHitCumul where dates between x and y group by pname order by sum(pagehit) desc, pname Jochem

RE: SQL SUM Question

2001-01-04 Thread bflynn
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-

RE: SQL SUM Question

2001-01-03 Thread Kurt Ward
Select Number from Tbl_Numbers SUM(Number) AS MyVar cfoutput#MyVar#/Cfoutput -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

Re: SQL SUM Question

2001-01-03 Thread Ricq Pattay
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,

RE: SQL SUM Question

2001-01-03 Thread LKHaas
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

RE: SQL SUM Question

2001-01-03 Thread Joshua Tipton
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

RE: SQL SUM Question

2001-01-03 Thread Joshua Tipton
Thats right I gorgot the as -Original Message- From: Kurt Ward [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 03, 2001 4:40 PM To: CF-Talk Subject: RE: SQL SUM Question Select Number from Tbl_Numbers SUM(Number) AS MyVar cfoutput#MyVar#/Cfoutput -Original Message