mssql2000 On Jan 1, 2008 3:07 PM, Greg Morphis <[EMAIL PROTECTED]> wrote:
> 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:295665 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
