I can't figure out how to output a query to the hundreth place, I can format
the number to the Hundereth, but CF or SQL Server round it to the nearest
number. I am currently running CF 4.5.1 with SQL Server.
Here's my query and output:
<cfquery name="GetTeamStats" datasource="#DS#" username="#DSUsername#"
password="#DSPassword#">
SELECT AVG(BB_BoxGame.HTotal) AS HomeAvg,
SUM(BB_BoxGame.HTotal) AS HomeTotal,
AVG(BB_BoxGame.VTotal) AS VisitAvg,
SUM(BB_BoxGame.VTotal) AS VisitTotal
FROM BB_BoxGame
WHERE BB_BoxGame.HomeID = 187 OR BB_BoxGame.VisitorID = 187
</cfquery>
<cfoutput query="GetTeamStats">
Home Average / #Numberformat(HomeAvg, "99.99")#<br>
Home Total / #HomeTotal#<br>
On the Road Average / #Numberformat(VisitAvg, "99.99")#<br>
On the Road Total / #VisitTotal#<br>
</cfoutput>
Thanks
Jason Larson
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists