You may have to use the QoQ.. if you bring the count up into the outer query you'll have to use GROUP BY defeating the sum() (unless you're using Oracle in which you can do a sum over. What RDBMS are you using?
On Jan 1, 2008 1:47 PM, morchella <[EMAIL PROTECTED]> wrote: > thats what i just said. > i can now get #get_totals.Sumtotal# > but not #get_totals.total# > > where befor i could get either using a qoq. > > <cfquery datasource="myBD" name="get_totals"> > Select SUM(total) AS Sumtotal > From ( > Select Count(*) AS total > From employees > WHERE emp_assigned = #get_Emp.usr_id# > ) AS derived_table > </cfquery> > On Jan 1, 2008 2:38 PM, Greg Morphis <[EMAIL PROTECTED]> wrote: > > > use > > query.sumtotal > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295658 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
