i am looking for a little help on this statement. what i want for it to do is grab the
point totals from the feilds called in the statement and then total them and out put
the total for the said contestant. this is what i have: (the answer should be 595 but
i get 2,630. if anyone can help from what i give you here that would be great and if
you need more info just let me know.... thanks,
<!--
<cfquery name="GetName"
datasource="rodeo"
dbtype="ODBC">
SELECT ContestantID
FROM ContestantManager
WHERE ContestantID = #url.ContestantID#
</cfquery>
<cfquery name="GetTotalPts"
datasource="rodeo"
dbtype="ODBC">
SELECT SUM (FirstPlaceAdjPts + FirstPlacePts + SecondPlacePts + SecondPlaceAdjPts +
ThirdPlacePts + ThirdPlaceAdjPts + FourthPlacePts + FourthPlaceAdjPts + FithPlacePts +
FithPlaceAdjPts + SixthPlacePts + SixthPlaceAdjPts) as TOTALPTS
FROM ResultManager
GROUP BY '#GetName.ContestantID#'
</cfquery>
-->
Thanks again,
Jay Patton
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists