That's because you need both to be inside pound signs: #total1.expr1 + total2.expr2#
-----Original Message----- From: alex poyaoan [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 26, 2008 8:35 AM To: cf-talk Subject: problem with sum of resuts of two queries 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:315967 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
