Title: RE: cfloop query
Thread: cfloop query
Forum: Need Help?
Conference: ColdBox
User: lmajano Hi,
This is a classic example of how to implement cfoutput groupby. There is
no need to call the component for the submenus according to menu id. All you
need to do, is order the query correctly so you can output it using the group by
functionality of cfoutput. Then, you would just need to retrieve the data in
your handlers, set it in the request collection, and then display it on your
view by nesting cfoutput's and using group by.
As a rule of thumb, no logical
code calling components for data should be done by the view. If you do, then
you are coupling that view to that data call, which is not what you want. You
want the separation.
http://forums.coldboxframework.com/index.cfm?event=ehMessages.dspMessages&threadid=0C0459A8-FF6E-E829-9A05177973C04160