Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
JimmyMacJimmyMac 

Logic for performing control break inside <cfrepeat>

Hi All,

 

I need to loop thru an orderd SObject list(Ordered by Policy Number)  and I was hoping to sum up the values as I looped for EACH POLICY NUMBER GROUP, and then perform a display a subtotal of the summed value, and then break after I get done with each Policy.

 

The reason I am doing the SUM in a loop and not in a query is that the object I need to query against does NOT allow Grouping by the Policy_Number field (Don't ask :))

 

Can someone tell me the "best practices" for doing this?

 

Thanks so much.

-Jim