Can anyone help me on this. here is my querey and then the output. it seems to be
rounding the SUM (TimeTaken) as TotalTime variable.
im tring to get it to output something like 12.03 or 03.98 ect....
<cfquery name="EventResults"
datasource="#datasource#"
dbtype="ODBC">
SELECT ContestantID, SUM (AdjPoints) as TOTALPTS, SUM (Points) as PTS, SUM (TimeTaken)
as TotalTime, RodeoID, Place
FROM ResultsManager
WHERE EventID = #url.EventID# AND RodeoID = #url.RodeoID#
GROUP BY ContestantID, RodeoID, Place
ORDER BY Place
</cfquery>
<cfoutput>#NumberFormat(EventResults.TotalTime,"___.__")#</cfoutput>
Thanks,
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
