#Evaluate(total1.Expr1 + total2.Expr1)# On Wed, Nov 26, 2008 at 8:34 AM, alex poyaoan <[EMAIL PROTECTED]> wrote:
> HI everybody just wondering if there is a way i could sum the results of > two queries and display it inside of cfoutput.. the queries are below > > <CFQUERY NAME="total1" datasource="db1"> > SELECT COUNT(id1) AS Expr1 > FROM table2 > </CFQUERY> > > <CFQUERY NAME="total2" datasource="db1"> > SELECT COUNT(id1) AS Expr1 > FROM table1 > </CFQUERY> > > like <cfoutput> > #total1.expr1#+#total2.expr2# > </cfoutput> > > but the above doesn't work > > thanks > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315965 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
