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?

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. Here
is the example:

<CFQUERY NAME="GetEarned" DBTYPE="query">
SELECT
TaskDesc.QTYComplete AS QTYComplete,
TaskDesc.Manhours AS Manhours,
(TaskDesc.Manhours *(TaskDesc.QTYComplete / TaskDesc.QTY)) AS Earned,
(TaskDesc.QTYComplete / TaskDesc.QTY) AS PercentComplete
FROM TaskDesc
</CFQUERY>


------------------------------------------
<!--- Add JSA Task --->
</TR><br>
<CFLOOP QUERY="TaskDesc" startrow="#URL.StartRow#"
endrow="#EndRow#"><cfoutput>
<TR>
<!--- Cust name --->
<TD><table width="550" border="1" bordercolor="FFFFFF"
cellspacing="0" cellpadding="0">
<tr>
<td width="100" align="center"><font size="-1">#ActivityID#</font></td>
<td width="200" align="center"bgcolor="FFFFFF"><font
size="-2">#ActivityDescription#</font></td>
<td width="50" align="center"><font size="-2">

<cfif GetEarned.QTYComplete IS "0">0
<cfelse>#GetEarned.Earned#</cfif>

</font></td>
<td width="50" align="center"><font size="-2">#Manhours#</font></td>
<td width="50" align="center"bgcolor="FFFFFF"><font size="-1"
color="006633">

<cfif GetEarned.QTYComplete IS "0">0
<cfelse>#GetEarned.PercentComplete#</cfif>

</cfoutput></cfloop>

I did get rid of some html code to clean it up a bit.

It would be simpler to add the math to the original query. Your q of q shows that you know how to do this.

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>

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?
>
> 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. Here
> is the example:
>
> <CFQUERY NAME="GetEarned" DBTYPE="query">
> SELECT
> TaskDesc.QTYComplete AS QTYComplete,
> TaskDesc.Manhours AS Manhours,
> (TaskDesc.Manhours *(TaskDesc.QTYComplete / TaskDesc.QTY)) AS Earned,
> (TaskDesc.QTYComplete / TaskDesc.QTY) AS PercentComplete
> FROM TaskDesc
> </CFQUERY>
>
> ------------------------------------------
> <!--- Add JSA Task --->
> </TR><br>
> <CFLOOP QUERY="TaskDesc" startrow="#URL.StartRow#"
> endrow="#EndRow#"><cfoutput>
> <TR>
> <!--- Cust name --->
> <TD><table width="550" border="1" bordercolor="FFFFFF"
> cellspacing="0" cellpadding="0">
> <tr>
> <td width="100" align="center"><font size="-1">#ActivityID#</font></td>
> <td width="200" align="center"bgcolor="FFFFFF"><font
> size="-2">#ActivityDescription#</font></td>
> <td width="50" align="center"><font size="-2">
>
> <cfif GetEarned.QTYComplete IS "0">0
> <cfelse>#GetEarned.Earned#</cfif>
>
> </font></td>
> <td width="50" align="center"><font size="-2">#Manhours#</font></td>
> <td width="50" align="center"bgcolor="FFFFFF"><font size="-1"
> color="006633">
>
> <cfif GetEarned.QTYComplete IS "0">0
> <cfelse>#GetEarned.PercentComplete#</cfif>
>
> </cfoutput></cfloop>
>
> I did get rid of some html code to clean it up a bit.

BTW:
<cfloop query="queryName" ...>
<cfoutput>
....
</cfoutput>
</cfloop>
can be replaced with shorter
<cfoutput query="queryName" ...>
....
</cfoutput>

Sometimes I can't see the forest through the trees! My loop was looping the main query no the query of the main. Thanks for the help