Thread: math
View Single Post
  #3 (permalink)  
Old 07-24-2008, 01:55 PM
GArlington
 
Posts: n/a
Diggs:
Default Re: math

On Jul 24, 12:35 pm, "chrispilie" <webforumsu...@macromedia.com>
wrote:
> I am trying to do some simple math equations with data from a query. This is
> what it may look like.
>
> #queryname.VariableA*#(#queryname.VariableB#/#quer yname.VariableC#) Is there
> any ideas?

<cfset res = queryname.VariableA*(queryname.VariableB/
queryname.VariableC) />
will work as well as your equation if you move * (multiplication)
outside the # [I suspect that this is just a typo in this post]
For your future posts DO NOT re-type your code - COPY and PASTE
exactly what you have...
>
> I can get these to work when setting them within a query of query but when I
> loop the variables they populate every value with its associated column...

Did you mean column name in ##?
Then you forgot to put <cfoutput ...>...</cfoutput> around your
equation...
<snap>
Reply With Quote