> >Why not just do it in SQL? > >SELECT Price, SUM(Price) As Total > From Products Oops, sorry about that, didn't notice the original field still in there, obviously you can't have that along with the aggregate function, should be just: SELECT SUM(Price) As Total From Products ------------------------------------------------------------------------ Mary Jo Sminkey [EMAIL PROTECTED] http://www.cfwebstore.com CFWebstore, Cold Fusion-based E-commerce ------------------------------------------------------------------------ ------------------------------------------------------------------------------ Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
