Hi I have this very simple SQL query select Sum(amount) as total from tbltotals where yearID =#getyear.yearID# and monthid=#month#
I loop over the query outputting #qry.total# for each month I want to keep a running total for that year but when I try to add it up I get a type mismatch error in CF I think I need to cast the total alias as a number but cant remember how :P a little help? Thanks |\--------------------/| Matt Horn Web Applications Developer Ph:+2782 424 3751 W: http://www.matt-horn.org E:[EMAIL PROTECTED] |\--------------------/|
