[whew] :-) On Wed, Nov 26, 2008 at 9:04 AM, Dave Watts <[EMAIL PROTECTED]> wrote:
> I think that's new CF8 syntax. > > Dave Watts, CTO, Fig Leaf Software > > -----Original Message----- > From: John M Bliss <[EMAIL PROTECTED]> > Sent: Wednesday, 26 November, 2008 09:46 > To: cf-talk <[email protected]> > Subject: Re: problem with sum of resuts of two queries > > Second relatively basic thing I learned about CFML syntax in as many days! > I've used this language for more than a decade and I didn't know you could > omit the Evaluate()! > > What else don't I know? :-) > > On Wed, Nov 26, 2008 at 8:40 AM, Andy Matthews <[EMAIL PROTECTED] > >wrote: > > > 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:315977 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
