Outputing the averaging a column of numbers in a table 1

dennis1000 · Nov 30, 2002

I am attempting to average a column of mumbers in a table. Did a search of threads that poroduced no results. I found the SQL statement in Que's text but cannot find any info on how to output it on a page. The data source is called ratepay, the table is called ratepay, access db is called rate and the table field is called Salary. Here's my start:

<CFQUERY NAME="GetAveSalary" DATASOURCE="ratepay">
SELECT AVG (Salary)
FROM ratepay
WHERE 0=0
</CFQUERY>

<html><body>

<CFOUTPUT Query="GetAveSalary">
#Salary#
</CFOUTPUT>
</body></html>

What am I doing wrong? Thanks for your help in advance.

DeZiner · Nov 30, 2002

Try:
<CFQUERY NAME="GetAveSalary" DATASOURCE="ratepay">
SELECT AVG (Salary) as newSal
FROM ratepay
WHERE 0=0
</CFQUERY>

<html><body>

<CFOUTPUT Query="GetAveSalary">
#newSal#

</CFOUTPUT>
</body></html>
DeZiner
Never be afraid to try something new.
Remember that amateurs built the Ark.
Professionals built the Titanic

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Outputing the averaging a column of numbers in a table 1

dennis1000

Programmer

DeZiner

Programmer

Similar threads

Part and Inventory Search

Sponsor