On Mon, 23 Feb 2004 09:40:24 +0200, Matt Horn <[EMAIL PROTECTED]> wrote:
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] |\--------------------/|
-- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
